Create Tableau TDE file using Python

||
Posted 4 years ago
||
Views 498
||
1 min read
0 reactions

import pandas
import dataextract as tde




# #########################################################

dataset= df.to_csv("irisExtract.csv", encoding='utf-8-sig')
dataset = pandas.read_csv(url, names=names)

# step 03 create a blank extract
# #########################################################
dataExtract = tde.Extract('irisExtract.tde')

# step 04 define schema
# #########################################################
dataSchema = tde.TableDefinition()
dataSchema.addColumn('sepal-length', tde.Type.DOUBLE)
dataSchema.addColumn('sepal-width', tde.Type.DOUBLE)
dataSchema.addColumn('petal-length', tde.Type.DOUBLE)
dataSchema.addColumn('petal-width', tde.Type.DOUBLE)
dataSchema.addColumn('class', tde.Type.CHAR_STRING)

# step 05 connect schema with blank extract
# #########################################################
table = dataExtract.addTable('Extract', dataSchema)

# step 06 fill extract with data
# #########################################################
newRow = tde.Row(dataSchema)
for i in range(0, len(dataset)):
    newRow.setDouble	(0, dataset['sepal-length'][i])
    newRow.setDouble		(1, dataset['sepal-width'][i])
    newRow.setDouble		(2, dataset['petal-length'][i])
    newRow.setDouble		(3, dataset['petal-width'][i])
    newRow.setCharString	(4, dataset['class'][i])
    table.insert(newRow)

# step 07 close the extract
# #########################################################
dataExtract.close()


0 reactions

Discussion

bhanupriyakuchana123
Posted 3 years, 6 months ago

good



Looking for Freelancing Jobs
Joined on April 15, 2020

Latest Videos