Renaming Column in Pandas Doesn't Do Anything
I'm Importing a Csv File Which Has the Following Header(Column Names): "Appendix","Name / Organization","Issuer","Algorithm" I Tried Changing the "Appendix"...
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!
2 Answers
Some methods to sort this out:
Restart the kernel and run again.
If it doesn't help, assign a list of new column names
df.columns = ['Other Info' , 'Name / Organization' , 'Issuer' , 'Algorithm']
Create a new column
Other Info, copy all the data fromAppendixand drop yourAppendixcolumn
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"]
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
