I'm importing a CSV file which has the following header(column names):

"Appendix","Name / Organization","Issuer","Algorithm"

I tried changing the "Appendix" column name into "Other Info" but it doesn't work.

df.rename(columns={'Appendix':'Other Info'}, inplace=True)

I get no error and when I print the dataframe again, it looks like the original one. (nothing has changed). I don't understand why. Can you give me an idea?

Thank you!

4

2 Answers

Some methods to sort this out:

1. Restart the kernel and run again.

2. If it doesn't help, assign a list of new column names

   df.columns = ['Other Info' , 'Name / Organization' , 'Issuer' , 'Algorithm']

3. Create a new column Other Info, copy all the data from Appendix and drop your Appendix column

make sure column name doesn't have any invisible characters line space and'\n'. The key u give in df.replace function should match the column name.

try theese

 df.rename(columns={'df.columns[0]':'Other Info'}, inplace=True)

or

 df.columns=["Other info","Name / Organization","Issuer","Algorithm"]

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy