xxxxxxxxxx
import pandas as pd
# Assuming the dataframe is already created and named 'df'
# Set a single column as the index
df.set_index('column_name', inplace=True)
# Set multiple columns as the index (creating a MultiIndex)
df.set_index(['column_name1', 'column_name2'], inplace=True)
# Reset the index to the default integer index
df.reset_index(inplace=True)
xxxxxxxxxx
# assignment copy
df = df.set_index('month')
# or inplace
df.set_index('month', inplace=True)
# year sale month month year sale
# 0 2012 55 1 1 2012 55
# 1 2014 40 4 => 4 2014 40
# 2 2013 84 7 7 2013 84
# 3 2014 31 10 10 2014 31
xxxxxxxxxx
df.reset_index(inplace=True)
df = df.rename(columns = {'index':'new column name'})
xxxxxxxxxx
df.set_index('col') # Set a single column as index
df.set_index(['col1','col2']) # Create multi-level index
xxxxxxxxxx
import pandas as pd
# Create a sample DataFrame
data = {'Name': ['John', 'Emma', 'Alex'],
'Age': [25, 28, 32],
'Country': ['USA', 'Canada', 'UK']}
df = pd.DataFrame(data)
# Set 'Name' column as the index column
df.set_index('Name', inplace=True)
# Display the updated DataFrame
print(df)
xxxxxxxxxx
#cree un indice par defaut sur la base de donnee
df.reset_index()