Answers for "python dataframe rename"

65

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
Posted by: Guest on March-13-2020
8

rename df column

import pandas as pd
data = pd.read_csv(file)
data.rename(columns={'original':'new_name'}, inplace=True)
Posted by: Guest on June-02-2020
10

pandas dataframe column rename

>>> df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})
>>> df.rename(columns={"A": "a", "B": "c"})
   a  c
0  1  4
1  2  5
2  3  6
Posted by: Guest on February-29-2020
0

rename one dataframe column python

#suppy as dict the column name to replace
df1 = df.rename(columns={'Name': 'EmpName'})
print(df1)
Posted by: Guest on May-30-2021
1

pd.series.rename

>>> s = pd.Series([1, 2, 3])
>>> s
0    1
1    2
2    3
dtype: int64
>>> s.rename("my_name")  # scalar, changes Series.name
0    1
1    2
2    3
Name: my_name, dtype: int64
>>> s.rename(lambda x: x ** 2)  # function, changes labels
0    1
1    2
4    3
dtype: int64
>>> s.rename({1: 3, 2: 5})  # mapping, changes labels
0    1
3    2
5    3
dtype: int64
Posted by: Guest on July-16-2020
0

dataframe rename column

df = pd.DataFrame({"A": [1, 2, 3], "B": [4, 5, 6]})

# Option 1
df.rename({"A": "a", "B": "c"}, axis=1)

# Option 2
df.rename(columns={"A": "a", "B": "c"})

# Result
   a  c
0  1  4
1  2  5
2  3  6
Posted by: Guest on March-10-2021

Code answers related to "python dataframe rename"

Python Answers by Framework

Browse Popular Code Answers by Language