Copy a column from a txt file to a column in Excel file, Python -


i trying copy contents of first 3 columns of txt file first 3 columns of excel file.

here code:

import xlsxwriter worksheet1 = workbook.add_worksheet() worksheet1.write('a1', 'time', bold);worksheet1.write('b1', 'user value', bold);worksheet1.write('c1','address', bold);worksheet1.write('d1', 'serial number', bold); items = os.listdir(directory) file in items:     if file.endswith('file.txt'):             fileselection = directory+'/' + file             array1 = []             open(fileselection, 'r') f:                     line in f:                         valueslist = line.split('\t')                         #print valueslist                         array1.append(valueslist)          j in range(len(array1)):             if j == 0:                 continue             else:                 print array1[j][0]                 worksheet1.write('a2:d2', array1[j][0]) #i want say, copy columns d start second raw

however copies whole txt array first column of excel file!

it looks 'text file' want csv, different delimiter (this bit of confusing convention). can use csv module specify this:

>>> import csv >>> open('your file.txt', 'rb') csvfile: ...     reader = csv.reader(csvfile, delimiter='\t') ...     row in reader: ...         print ', '.join(row)

there similar csv writer module, or want excel file?

i have noticed in code maybe valueslist should truncate first 3 columns, appear want...

this why getting of original file. change 

 valueslist = line.split('\t')

to 

valueslist = line.split('\t')[:3]

Comments

Post a Comment

Popular posts from this blog

asynchronous - C# WinSCP .NET assembly: How to upload multiple files asynchronously -

i using winscp .net assembly uploading files. want upload multiple files asynchronous way. have created method works single upload. public class uploadingdata { private sessionoptions _sessionoptions; private session _session; //connection etc private void onconnected() { foreach (var fileinfo in localfileslist) { var task = task.factory.startnew(() => uploadfilesasync(fileinfo)); } } private async task uploadfilesasync(string file) { string remotefilepath = _session.translatelocalpathtoremote(file, @"/", "/test_data_upload"); var uploading = _session.putfiles(file, remotefilepath, false); //when done await task.run(() => thread.sleep(1000)); } } please suggest me correct way. thanks you can use backgroundworker class this: string[] images = new string[50]; foreach (var path in images) { backgroundworker
Read more

aws api gateway - SerializationException in posting new Records via Dynamodb Proxy Service in API -

i getting "__type": "com.amazon.coral.service#serializationexception" as reply in postman & in test console in api gateway trying post record directly dynamodb using api proxy services.. referring aws article - https://aws.amazon.com/blogs/compute/using-amazon-api-gateway-as-a-proxy-for-dynamodb/ here's mapping { "tablename": "tablenamegoeshere", "item": { "id" : "$context.requestid" "eventname" : "$input.path('$.eventname')", "timestamp" : $input.path('$.timestamp'), "answers": "$util.parsejson($input.path('$.answers'))" } } update: did asked ... , worked if try add array of json objects gives me above same error - here's trying now. please - couldnt find on google well #set($inputroot = $input.path('$')) { "tablename": "answer", "item": {
Read more

asp.net - Problems sending emails from forum -

i have been redesigning site has message board, has been written guy looked after site. it has few problems , written in .asp , uses .mdb files database. you can see whole thing here . feel free post if helps, test thing have set using original files , new database. the basic problem when posts message, supposed email sent them, have posted it. when replies, originator supposed message, replier has been posted. i’d have thought @ point in process there should script/file in postmessage.asp? the postmessage.asp page below. <% option explicit %> <!-- #include virtual="common/adovbs.inc" --> <html> <head> <meta http-equiv="content-type" content="text/html; charset=windows-1252"> <meta name="generator" content="microsoft frontpage 4.0"> <meta name="progid" content="frontpage.editor.document"> <title>new page 2</title> <base target="_self"
Read more