python - Reading in csv file to pandas fails -


i have csv file generated exporting tableau table csv, can not manage open in python.

i have tried use pd.read_csv fails.

import pandas pd  #path file path = "tableau_crosstab.csv"  data = pd.read_csv(path, encoding="iso-8859-1")

this works reading in file, result number of rows 1 character per row, , weird characters in head of frame.

ÿþd o     m

and on. when try import file in excel have select tab separator, when trie here fails

import pandas pd  #path file path = "tableau_crosstab.csv"  data = pd.read_csv(path, encoding="iso-8859-1", sep='\t')

cparsererror: error tokenizing data. c error: expected 1 fields in line 7, saw 2

i did try open file codecs, , says encoding 'cp1252', using encoding fails too.

i tried read in using utf-8 , fails. running out of ideas how solve this.

here link copy if file if take http://www.mediafire.com/file/6dtxo2deczwy3u2/tableau_crosstab.csv

you have unicode bom utf-16le

try 

data = pd.read_csv(path, encoding="utf-16", sep='\t')

the funny characters see: ÿþ corresponds hex ff fe unicode-16 little endian byte order mark. if see wikipedia page shows various byte order marks

i following when reading csv:

in[4]: data = pd.read_csv(r'c:\tableau_crosstab.csv', encoding='utf-16', sep='\t') data  out[4]:         domain month of date impressions clicks 0    test1.no        jun.17     725 676    633 1    test1.no        mai.17     422 995    456 2    test1.no        apr.17     241 102    316 3    test1.no        mar.17     295 157    260 4    test1.no        feb.17     122 902    198 5    test1.no        jan.17     137 972    201 6    test1.no        des.16     274 435    361 7   test2.com        jun.17   3 083 373  1 638 8   test2.com        mai.17   3 370 620  2 036 9   test2.com        apr.17   2 388 933  1 483 10  test2.com        mar.17   2 410 675  1 581 11  test2.com        feb.17   2 311 952  1 682 12  test2.com        jan.17   1 184 787    874 13  test2.com        des.16   2 118 594  1 738 14  test3.com        jun.17     411 456     41 15  test3.com        mai.17     342 048     87 16  test3.com        apr.17     197 058    108 17  test3.com        mar.17     288 949    156 18  test3.com        feb.17     230 970    130 19  test3.com        jan.17     388 032    115 20  test3.com        des.16   1 693 442    166 21   test4.no        jun.17     521 790    683 22   test4.no        mai.17     438 037    541 23   test4.no        apr.17     618 282  1 042 24   test4.no        mar.17     576 413    956 25   test4.no        feb.17     451 248    636 26   test4.no        jan.17     293 217    471 27   test4.no        des.16     641 491    978

Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more