Answer a question

I'm trying to join two dataframes in Pandas.

The first frame is called Trades and has these columns:

TRADE DATE
ACCOUNT
COMPANY
COST CENTER
CURRENCY

The second frame is called Company_Mapping and has these columns:

ACTUAL_COMPANY_ID
MAPPED_COMPANY_ID

I'm trying to join them with this code:

trade_df = pd.merge(left=Trades, right = Company_Mapping, how = 'left', left_on = 'COMPANY', right_on = 'ACTUAL_COMPANY_ID'

This returns:

KeyError: 'COMPANY'

I've double checked the spelling and COMPANY is clearly in Trades, and I have no clue what would cause this.

Any ideas?

Thanks!

Answers

Your Trades dataframe has a single column with all the intended column names mashed together into a single string. Check the code that parses your file.