Rename first row in a CSV file

[James_S]

I don't know what I have done wrong. I want to rename the first row of the table:

renamed_df = pd.read_csv('my_data.csv')

# Change column names
renamed_df.rename(columns={'AA': 'aaa', 'BB': 'bbb', 'CC': 'ccc', 'DD': 'ddd', 'EE': 'eee'}, inplace=True)

# Save the renamed DataFrame to a new CSV file
renamed_df.to_csv('renamed_my_data.csv', index=False)

renamed_df.head()

Yoriz write Dec-17-2023, 01:19 AM:
Please post all code, output and errors (in its entirety) between their respective tags. Refer to BBCode help topic on how to post. Use the "Preview Post" button to ensure the code is presented as you expect before hitting the "Post Reply/Thread" button.

[James_S]

Input (my_data.csv):

39, AA, BB, CC, DD, EE
40, 111,222,333,444,555
41,666,777,888,999,000
42,121,232,343,454,565
43,244,355,366,377,388

Expected output (renamed_my_data.csv)

39, aaa, bbb, ccc, ddd, eee
40, 111,222,333,444,555
41,666,777,888,999,000
42,121,232,343,454,565
43,244,355,366,377,388

[deanhystad]

Your first column name is " AA", not "AA". You need to tell pandas that there may be extra whitespace

df = pd.read_csv('my_data.csv', skipinitialspace=True)

[James_S]

deanhystad,

Thank you. It works.