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

Tutto è chiaro?

Grazie per i tuoi commenti!

Sezione 1. Capitolo 6

Chieda ad AI

Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione

Contenuti del Corso

Introduction to pandas [track]