search

dgunning / edgartools

Navigate SEC Edgar data in Python
MIT License
418 stars 84 forks source link

Keep on getting the same error (please help) #91

Closed david08-08 closed 1 week ago

david08-08 commented 3 weeks ago

Cell In[19], line 29 revenue = income_statement_df.loc[income_statement_df['label'].str.contains('Revenue', case=False, na=False)].iloc[0, 1]

File /opt/anaconda3/envs/nlp_env/lib/python3.11/site-packages/pandas/core/frame.py:4102 in getitem indexer = self.columns.get_loc(key)

File /opt/anaconda3/envs/nlp_env/lib/python3.11/site-packages/pandas/core/indexes/base.py:3812 in get_loc raise KeyError(key) from err

KeyError: 'label'

dgunning commented 3 weeks ago

I think the column label is used as the index Try

income_statement_df[income_statement_df.index.str.contains('Revenue')]
dgunning commented 3 weeks ago

You can do this to get the values if you know the label or the concept name

# By concept
balance_sheet.get_concept('us-gaap_AccountsReceivableNetCurrent').values
# By label
 balance_sheet.get_concept(label='Accounts receivable, net').values
dgunning commented 1 week ago

Closed as question answered