/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

0 vote235 views1 answer
Display Surface quit
Python
87 votes245 views6 answers
How to convert string to datetime
Python
11 votes256 views4 answers
Invert a dictionary python
Python
5 votes234 views2 answers
How to draw image in tkinter
Python
0 vote236 views1 answer
Django-filter field name greater than
Python Django
0 vote210 views1 answer
Update cell in sheet by column name using pandas
Python
-3 votes252 views1 answer
Django socketio web chat example
Python Django
0 vote230 views1 answer
Return position of a unique value in python array
Python
14 votes276 views5 answers
How to import modules in python
Python
11 votes250 views6 answers
Python get file size
Python