/Python/How to rename columns using panda object

How to rename columns using panda object

Rename columns pandas

df.rename(columns={'oldName1': 'newName1',
                   'oldName2': 'newName2'},
          inplace=True, errors='raise')
# Make sure you set inplace to True if you want the change
# to be applied to the dataframe

Rename column pandas

df_new = df.rename(columns={'A': 'a'}, index={'ONE': 'one'})
print(df_new)
#         a   B   C
# one    11  12  13
# TWO    21  22  23
# THREE  31  32  33

print(df)
#         A   B   C
# ONE    11  12  13
# TWO    21  22  23
# THREE  31  32  33

Source: note.nkmk.me

Pandas dataframe rename column

df = df.rename(columns={'oldName1': 'newName1', 'oldName2': 'newName2'})
# Or rename the existing DataFrame (rather than creating a copy) 
df.rename(columns={'oldName1': 'newName1', 'oldName2': 'newName2'}, inplace=True)

Source: stackoverflow.com

Rename column pandas

>>> df.rename(index={0: "x", 1: "y", 2: "z"})
   A  B
x  1  4
y  2  5
z  3  6

Source: pandas.pydata.org

How to rename columns using panda object

df2.columns = stocks['Ticker'][:3]

[:3] is just use first 3
[5::] skip first 5



				price price  price 
2021-01-11	131.90	15.00	179.07
2021-01-12	128.09	15.74	182.65

to

Ticker	A	AAL	AAP
2021-01-11	131.90	15.00	179.07
2021-01-12	128.09	15.74	182.65

Source: stackoverflow.com

Similar codes

5 votes173 views1 answer
Pythagoras calculator
Python
10 votes218 views4 answers
How to know if python is 64 or 32 bit
Python
1 vote199 views1 answer
Panda Series Function
Python
1 vote181 views1 answer
Enumerate vs zip python same time
Python
0 vote173 views1 answer
Django trigger when an instance od data is deleted from model
Python
0 vote173 views1 answer
How to run a seaborn plot on pycharm
Python
0 vote182 views2 answers
Adding labels to histogram bars in matplotlib
Python
42 votes172 views6 answers
If key in dictionary python
Python
21 votes167 views2 answers
How to stop running code in python
Python
2 votes212 views1 answer
Hyperlinks in jupyter notebook
Python