如何使用Python将.csv格式文件转换为.tde格式文件(tableau extract)?

2024-05-19 10:29:35 发布

您现在位置:Python中文网/ 问答频道 /正文

以下是我面临的问题

我无法使用下面的命令正确安装dataextract包,因此在导入包时遇到问题。在

"python -m pip install dada extract"

tableau_rest_api包中,下面的命令也面临问题

^{pr2}$

有谁能告诉我执行相同任务的替代方法或帮助我更正现有代码吗

    #######convert .csv file to .tde file#########################
import os,csv,datetime
import dataextract as tde
# INSERT EXCEPT CONDITION
# EXTRACT FILE AND OPEN .CSV
try:
    tdefile = tde.Extract('trial1.tde')
except:
    os.remove('trial1.tde')``
    tdefile = tde.Extract('trial1.tde')

csvReader= csv.reader(open('test1.csv','rb'),delimiter=',',quotechar='"')

# CREATE THE TABLE DEF
tableDef= tde.TableDefinition()
tableDef.addColumn('Country',tde.Type.CHAR_STRING)
tableDef.addColumn('sales',tde.Type.INTEGER)
tableDef.addColumn('units',tde.Type.INTEGER)

# CREATE TABLE
table=tdefile.addTable('C:\Users\Mahita.Gm\Desktop\Extract',tableDef)

# DATA TO TDE

newrow= tde.Row(tableDef)
csvReader.next()
for line in csvReader:
    newrow.setCharString(0,str(line[0]))
    newrow.setInteger(1,int(line[1]))
    newrow.setInteger(2,int(line[2]))
    table.insert(newrow)

# closing tde
tdefile.close()

#############code to publish tableau extract in to server #################
import tableau_rest_api
from tableau_rest_api.tableau_rest_api import * import urllib2
username = '<user name>'
password = '<password>'
server = '<server address>'
logger = Logger('publish.log')

test = TableauRestApi(server, username, password)
test.enable_logging(logger)
test.signin()

test_ds_proj_luid = test.query_project_luid_by_name('default')
#test_ds_wb_luid = test.query_workbook_luid_by_name('test_1_c_CF')

#test_ds_p_luid = test.query_datasource_luid_by_name_in_project('trial1', 'test_1_c_CF')
# Publishing up my first data source to Test, from disk
new_ds_luid = test.publish_datasource('trial1.tde', 'trial1', test_ds_proj_luid, overwrite=True)

Tags: csvtotestimportrestapilineds

热门问题