Loading Your Dataset

You might want to check that the file you have downloaded is actually a CSV file with data in it. The first lines of the file SHOULD look like:

gameorder,game_id,lg_id,_iscopy,year_id,date_game,seasongame,is_playoffs,team_id,fran_id,pts,elo_i,elo_n,win_equiv,opp_id,opp_fran,opp_pts,opp_elo_i,opp_elo_n,game_location,game_result,forecast,notes
1,194611010TRH,NBA,0,1947,11/1/1946,1,0,TRH,Huskies,66,1300,1293.2767,40.29483,NYK,Knicks,68,1300,1306.7233,H,L,0.64006501,
1,194611010TRH,NBA,1,1947,11/1/1946,1,0,NYK,Knicks,68,1300,1306.7233,41.70517,TRH,Huskies,66,1300,1293.2767,A,W,0.35993499,
2,194611020CHS,NBA,0,1947,11/2/1946,1,0,CHS,Stags,63,1300,1309.6521,42.012257,NYK,Knicks,47,1306.7233,1297.0712,H,W,0.63110125,
...

When I first tried it, I ended up with HTML content from GitHub telling me, ” (Sorry about that, but we can’t show files that are this big right now.)” – so when I tried to run the command

nba = pd.read_csv('nba_all_elo.csv')

I ended up getting an error inside Pandas:

ParserError: Error tokenizing data. C error: Expected 1 fields in line 80, saw 2

How did I solve this problem? I went to my browser to view the CSV file, got to viewing the actual data, and then saved that data/file as nba_all_elo.csv

Am I looking in the wrong place or did you not provide the URL for the website in the transcript?

The URL is available on the Description tab.

The url in the descrpition for the nba data may download the html page, in which case try the following:

download_url = 'https://raw.githubusercontent.com/fivethirtyeight/data/master/nba-elo/nbaallelo.csv'

yikes. well I get this error when trying to very panda version I’m assuming I need to correct a path or directory. but clueless on how to do it

AttributeError Traceback (most recent call last) C:\Users\PNMCDO~1\AppData\Local\Temp/ipykernel_10256/116837967.py in <module> ----> 1 print(pd.version)

~\Anaconda3\lib\site-packages\pandas__init__.py in getattr(name) 242 return _SparseArray 243 –> 244 raise AttributeError(f”module ‘pandas’ has no attribute ‘{name}’“) 245 246

AttributeError: module ‘pandas’ has no attribute ‘version‘

ok. realize my problem!!!!!! it (pd. version) i had pd.version) i only typed one _ when it was two __ now on to the next question, which if we loaded pandas as pd and verified the version. why is it necessary to load it again ?

@pnmcdos It’s not necessary to load it again. The duplicate line was made by mistake. You can disregard it.

@markcerv Thank you! I just stumbled on the same error and solved it as you said.

So I can see the CSV when accessing it on my browser, but with the requests library I’m getting a back a JSON response, see image

Does anyone know how to get the CSV with requests from the Github of current day?

Following up the previous message, it seems to work when I add in the same “accept” header value from my browser in the request. So:

headers = {"Accept": "ext/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8"}

response = requests.get(download_url, headers=headers)

Hi there, apologies if the answer is obvious, but why did you need to import pandas twice (in line 1 then line 9)? Did the scope change in between?

Oops, I think someone else already asked this. My mistake.

When I try to run:

!dir

I get the following error:

PermissionError: [WinError 5] Access is denied

I’m running the notebook as administrator. Still the same problem. Can you help me out, please?

I’m typing print(pd._version_) but I’m getting the below error.

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
Cell In[4], line 1
----> 1 print(pd._version_)

AttributeError: module 'pandas' has no attribute '_version_'

I did put the underscores either side of version but for some reason your comment box won’t let me add them and changes version to italics.

@Evan Davies The underscores get interpreted as italics since the comment boxes support the Markdown syntax, which helps embed code snippets. I fixed your comment, but it looks like you need to use double underscores (dunder) instead of single ones:

>>> import pandas as pd

>>> pd.__version__
'2.2.2'

>>> pd._version_
Traceback (most recent call last):
  ...
AttributeError: module 'pandas' has no attribute '_version_'. Did you mean: '__version__'?

I had the same error first mentioned by @markcerv. I found that changing “blob” in the original URL to “raw” sorted things out. The url should be github.com/fivethirtyeight/data/raw/master/nba-elo/nbaallelo.csv

In order to solve de problem –> “year_id” != year from “date_game”:

nba["date_game"] = pd.to_datetime(nba["date_game"])  
nba["date_game"] = nba["date_game"].astype(str)

def DateRepair(row):
    year_from_date = row["date_game"][0:4]
    if year_from_date != str(row["year_id"]):
                             return year_from_date
    else:
        return fila["year_id"]