Indexes and Columns

You can change DataFrame' indexes likewise Series' indexes (by assigning necessary list to the .index attribute of DataFrame).


              12345678
            
# 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,


              123456
            
# 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.


              12345678910
            
# 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).

Was alles duidelijk?

Bedankt voor je feedback!

Sectie 1. Hoofdstuk 6

Vraag AI

Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.

Cursusinhoud

Introduction to pandas [track]