python - Pandas - Columns not read though Present -


i have following set of data. 

url, team1, team2, win_toss, bat_or_bowl, outcome, win_game, date,day_n_night, ground, rain, duckworth_lewis, match_id, type_of_match "espncricinfo-t20/145227.html","western australia","victoria","victoria","bat","western australia won 8 wickets (with 47 balls remaining)","western australia"," jan 12 2005","1"," western australia cricket association ground,perth","0","0","145227","t20" "espncricinfo-t20/212961.html","australian institute of sports","new zealand academy","new zealand academy","bowl","match tied",""," jul 7 2005 ","0"," albury oval, brisbane","0","0","212961","t20" "espncricinfo-t20/216598.html","air india","new south wales","air india","bowl","air india won 7 wickets (with 5 balls remaining)","air india"," aug 19 2005 ","0"," m chinnaswamy stadium, bangalore","0","0","216598","t20" "espncricinfo-t20/216620.html","karnataka state cricket association xi","bradman xi","bradman xi","bowl","karnataka state cricket association xi won 33 runs","karnataka state cricket association xi"," aug 20 2005 ","0"," m chinnaswamy stadium, bangalore","0","0","216620","t20" "espncricinfo-t20/216633.html","chemplast","bradman xi","chemplast","bat","bradman xi won 6 wickets (with 13 balls remaining)","bradman xi"," aug 20 2005 ","0"," m chinnaswamy stadium, bangalore","0","0","216633","t20"

this python console :

**

>>> import pandas pd >>> df = pd.read_csv("sample.txt" , quotechar = '\"') >>> df.shape (9, 14)   >>> df.columns index([u'url', u' team1', u' team2', u' win_toss', u' bat_or_bowl',        u' outcome', u' win_game', u' date', u' day_n_night', u' ground',        u' rain', u' duckworth_lewis', u' match_id', u' type_of_match'],       dtype='object')   >>> df.url.head() 0    espncricinfo-t20/145227.html 1    espncricinfo-t20/212961.html 2    espncricinfo-t20/216598.html 3    espncricinfo-t20/216620.html 4    espncricinfo-t20/216633.html name: url, dtype: object   >>> df.team1.head() traceback (most recent call last):   file "<stdin>", line 1, in <module>   file "/usr/local/python27/lib/python2.7/site-packages/pandas/core/generic.py", line 2744, in __getattr__     return object.__getattribute__(self, name) attributeerror: 'dataframe' object has no attribute 'team1'    >>> df.iloc[1:2]                             url                           team1  \ 1  espncricinfo-t20/212961.html  australian institute of sports                   team2             win_toss  bat_or_bowl     outcome  \ 1  new zealand academy  new zealand academy         bowl  match tied     win_game          date   day_n_night                  ground   rain  \ 1       nan   jul 7 2005              0   albury oval, brisbane      0      duckworth_lewis   match_id  type_of_match 1                 0     212961            t20

we can see column team1 exists unable retrieve df. error columns except first . please me find problem here ! thanks

you have leading space:

u' team1'

in column raises keyerror

do this:

pd.read_csv("sample.txt" , quotechar = '\"', skipinitialspace=true)

so csv read , ignores leading space

see docs


Comments

Post a Comment

Popular posts from this blog

Command prompt result in label. Python 2.7 -

i want put result(output) of shell command label. command works, label shows "0", however, in command prompt, result shown correctly, need showed in label. doing ubuntu. myg1 = button(root, text="rodyti informacija", command=lambda: gauti()) myg1.pack(side=bottom) def gauti(): imti = tekstas.get("1.0", "end-1c") info = subprocess.call("id '{imti}' ".format(imti=imti), shell=true) w = label(root, text= info) w.pack(side = bottom) subprocess.call() returns exit code of process created (in case 0 success). if want text output of process, should instead call subprocess.check_output() .
Read more

javascript - How do I use URL parameters to change link href on page? -

i change href value of link using url parameters. example: default <a id="dlink" href="link-1">link</a> but, when user goes https://url.com/?dlink=link-2 it swaps out link new link <a id="dlink" href="link-2">link</a> first need value url. if you're not using javascript framework can create function using jquery. please check get url parameter jquery or how query string values in js it. after that, element "a" id , set value there. $("#dlink").attr("href", hreffromparam);
Read more

amazon web services - AWS Route53 Trying To Get Site To Resolve To www -

so have domain nameservers pointed aws route 53. site hosted on ec2 instance , reachable resolves site.com, if input www.site.com. i'm curious how site resolve www.site.com. have under route53 domains hosted zone 2 additional record sets outside of ns , soa: a site.com ec2 elastic ip cname www.site.com ec2 public dns i can reach site using both site.com , www.site.com, resolve site.com. there way make if enter either, resolves www.site.com? at first, both should record set. a site.com ec2 elastic ip www.site.com ec2 elastic ip and need redirect setting in web server (nginx, apache, ..) following. (source: how redirect www non-www nginx on centos 7 ) redirect non-www www if want redirect users plain, non-www domain www domain, add server block: server { server_name example.com; return 301 $scheme://www.example.com$request_uri; } save , exit. configures nginx redirect requests "example.com" "www.example.com". not
Read more