Python Pandas : Replace or change Column & Row index names in DataFrame
In this article we will discuss how to change column names or Row Index names in DataFrame object.
First of all, create a dataframe object of students records i.e.
|
1 2 3 4 5 6 |
students = [ ('jack', 34, 'Sydeny') , ('Riti', 30, 'Delhi' ) , ('Aadi', 16, 'New York') ] # Create a DataFrame object dfObj = pd.DataFrame(students, columns = ['Name' , 'Age', 'City'], index=['a', 'b', 'c']) |
Contents of DataFrame objects are as follows,
|
1 2 3 4 |
Name Age City a jack 34 Sydeny b Riti 30 Delhi c Aadi 16 New York |
Change Column Names in DataFrame
DataFrame object has an Attribute columns that is basically an Index object and contains column Labels of Dataframe. We can get the ndarray of column names from this Index object i.e.
|
1 2 |
# Get ndArray of all column names columnsNamesArr = dfObj.columns.values |
Any modification in this ndArray (df.column.values) will modify the actual DataFrame. For example let’s change the name of column at index 0 i.e.
|
1 2 3 4 5 |
# Get ndArray of all column names columnsNamesArr = dfObj.columns.values # Modify a Column Name columnsNamesArr[0] = 'Test' |
This change will be reflected in linked DataFrame object too. Now contents of DataFrame object is,
|
1 2 3 4 |
Test Age City a jack 34 Sydeny b Riti 30 Delhi c Aadi 16 New York |
But we convert it to list before modifying then changes will not be reflected in original DataFrame object.
For example create a list of Column Names of DataFrame i.e.
|
1 2 |
# get a copy list of all the column names columnsNames = list(dfObj.columns.values) |
or
|
1 |
columnsNames = list(dfObj) |
Now modify the list,
|
1 2 |
# Modify Column Name columnsNames[0] = 'Test_Name' |
This modification will not be reflected in original DataFrame object and DataFrame object will remain same i.e.
|
1 2 3 4 |
Test Age City a jack 34 Sydeny b Riti 30 Delhi c Aadi 16 New York |
Change Row Index in DataFrame
Contents of dataframe objects is as follows,
|
1 2 3 4 |
Test Age City a jack 34 Sydeny b Riti 30 Delhi c Aadi 16 New York |
To get the list of all row index names from a dataFrame object, use index attribute instead of columns i.e. df.index.values
|
1 2 |
# get a list of all the column names indexNamesArr = dfObj.index.values |
It returns an ndarray of all row indexes in dataframe. Any modification in this ndArray (df.index.values) will modify the actual DataFrame. For example let’s change the name of row index at position 0 i.e.
|
1 2 |
# Modify a Row Index Name indexNamesArr[0] = 'P' |
This change will be reflected in linked DataFrame object too. Now contents of DataFrame object is,
|
1 2 3 4 |
Test Age City P jack 34 Sydeny b Riti 30 Delhi c Aadi 16 New York |
But if we convert it to list before modifying then changes will not be reflected in original DataFrame object. For example create a copy list of Row Index Names of DataFrame i.e.
|
1 2 |
# get a copy list of all the column names indexNames = list(dfObj.index.values) |
Complete example is as follows :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 |
import pandas as pd def main(): students = [ ('jack', 34, 'Sydeny') , ('Riti', 30, 'Delhi' ) , ('Aadi', 16, 'New York') ] # Create a DataFrame object dfObj = pd.DataFrame(students, columns = ['Name' , 'Age', 'City'], index=['a', 'b', 'c']) print("Original DataFrame : " , dfObj, sep="\n"); ''' Get All Columns Names in DataFrame ''' # Get ndArray of all column names columnsNamesArr = dfObj.columns.values print("Column Names : " , columnsNamesArr) ''' Get Columns Name by Index/position in DataFrame ''' print("Column Names at index 2: " , dfObj.columns.values[2]) ''' Pandas : Modify Column Name in DataFrame ''' # Modify a Column Name columnsNamesArr[0] = 'Test' print("Modified Column Names : " , columnsNamesArr) print("Modified DataFrame : ") print(dfObj) ''' Get Copy of all Columns Names in DataFrame ''' # get a copy list of all the column names columnsNames = list(dfObj.columns.values) print("Column Names : " , columnsNames) # Modify Column Name columnsNames[0] = 'Test_Name' print("Modified Column Names : " , columnsNames) print("DataFrame : ") print(dfObj) ''' Get List of All Index Names in DataFrame ''' # get a list of all the column names indexNamesArr = dfObj.index.values print("All Index Names : " , indexNamesArr) ''' Get Row Index Names in DataFrame by Poisition ''' print("Row Index Names at position 2: " , dfObj.index.values[2]) ''' Pandas : Modify Row Index Name in DataFrame ''' # Modify a Row Index Name indexNamesArr[0] = 'P' print("Modified Row Index Names : " , indexNamesArr) print("Modified DataFrame : ", dfObj, sep='\n') ''' Get Copy of all Row Index Names in DataFrame ''' # get a copy list of all the column names indexNames = list(dfObj.index.values) print("All Row Index Names : " , indexNames) if __name__ == '__main__': main() |
Output:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 |
Original DataFrame : Name Age City a jack 34 Sydeny b Riti 30 Delhi c Aadi 16 New York Column Names : ['Name' 'Age' 'City'] Column Names at index 2: City Modified Column Names : ['Test' 'Age' 'City'] Modified DataFrame : Test Age City a jack 34 Sydeny b Riti 30 Delhi c Aadi 16 New York Column Names : ['Test', 'Age', 'City'] Modified Column Names : ['Test_Name', 'Age', 'City'] DataFrame : Test Age City a jack 34 Sydeny b Riti 30 Delhi c Aadi 16 New York All Index Names : ['a' 'b' 'c'] Row Index Names at position 2: c Modified Row Index Names : ['P' 'b' 'c'] Modified DataFrame : Test Age City P jack 34 Sydeny b Riti 30 Delhi c Aadi 16 New York All Row Index Names : ['P', 'b', 'c'] |
If you didn't find what you were looking, then do suggest us in the comments below. We will be more than happy to add that.
Leave a Reply