search

davidrpugh / pyBEA

Python package for downloading data from the Bureau of Economic Analysis (BEA) data API.
MIT License
68 stars 28 forks source link

Duplicate entries in DataSetName='RegionalData'. #2

Closed davidrpugh closed 10 years ago

davidrpugh commented 10 years ago

Running...

data = pybea.get_data(UserID='INSERT_USER_ID', DataSetName='RegionalData', KeyCode='POP_CI', GeoFips='MSA', Year='2010')

...in IPython yields:

In [6]: data.head()
Out[6]: 
  CL_UNIT    Code  DataValue  GeoFips  \
0    PERS  POP_CI  263028121      998   
1    PERS  POP_CI     165578    10180   
2    PERS  POP_CI     165578    10180   
3    PERS  POP_CI     703055    10420   
4    PERS  POP_CI     703055    10420   

                                       GeoName NoteRef  TimePeriod  UNIT_MULT  
0         United States (Metropolitan Portion)     NaN        2010          0  
1  Abilene, TX (Metropolitan Statistical Area)     NaN        2010          0  
2                            Abilene, TX (MSA)     NaN        2010          0  
3    Akron, OH (Metropolitan Statistical Area)     NaN        2010          0  
4                              Akron, OH (MSA)     NaN        2010          0

Note the duplicate entries under GeoName! This is a bug on the BEA end.

davidrpugh commented 10 years ago

I have notified the BEA of this behavior.

davidrpugh commented 10 years ago

BEA has fixed the issue! Took less than 30 minutes.