Course Content
Introduction to pandas [track]
Introduction to pandas [track]
Indexes and Columns
You can change DataFrame' indexes likewise Series' indexes (by assigning necessary list to the .index
attribute of DataFrame).
# Importing library import pandas as pd # Creating DataFrame df = pd.DataFrame([[1, 2], [3, 4], [5, 6]]) # Set indexes df.index = ['first', 'second', 'third'] print(df)
You can set indexes when defining the DataFrame by specifying the index
parameter. For instance,
# Importing library import pandas as pd # Creating DataFrame with indexes df = pd.DataFrame([[1, 2], [3, 4], [5, 6]], index = ['first', 'second', 'third']) print(df)
Also there are two ways to set the columns names: by assigning list of names to the columns
attribute, or specifying the columns
parameter.
# Importing library import pandas as pd # Creating DataFrame with indexes df = pd.DataFrame([[1, 2], [3, 4], [5, 6]], columns = ['col1', 'col2'], index = ['first', 'second', 'third']) print(df) # Changing columns' names df.columns = ['Column1', 'Column2'] print(df)
If you need to change columns' names or indexes of existing dataframe, use the approach with reassigning (
.index
,.columns
attributes).
Thanks for your feedback!