Handling Index of pandas DataFrame in Python (Example) | How to Use Indices | Convert, Set & Merge

Опубликовано: 09 Февраль 2025
на канале: Statistics Globe

291

How to manipulate the index of a pandas DataFrame in the Python programming language. More details: https://statisticsglobe.com/index-pan...
Python code of this video:

import pandas as pd # Import pandas library

data = pd.DataFrame({'x1':range(1, 10), # Create pandas DataFrame
'x2':['a', 'b', 'b', 'a', 'd', 'a', 'a', 'b', 'd'],
'x3':range(30, 21, - 1),
'x4':['x', 'z', 'z', 'y', 'y', 'z', 'x', 'z', 'x']})
print(data) # Print pandas DataFrame

data_new1 = data.copy() # Duplicate DataFrame
data_new1['index'] = data_new1.index # Convert index to column
print(data_new1) # Print updated DataFrame

data_new2 = data.set_index('x3') # Convert column to index
print(data_new2) # Print updated DataFrame

data_new3 = data_new2.reset_index() # Reindex rows of pandas DataFrame
print(data_new3) # Print updated DataFrame

data2 = pd.DataFrame({'y1':['a', 'a', 'b', 'c', 'c'], # Create second pandas DataFrame
'y2':range(30, 25, - 1),
'y3':['x', 'z', 'z', 'x', 'x']},
index = range(6, 11))
print(data2) # Print pandas DataFrame

data_new4 = pd.merge(data, # Join based on index
data2,
left_index = True,
right_index = True)
print(data_new4) # Print updated DataFrame

Follow me on Social Media:
Facebook – Statistics Globe Page:   / statisticsglobecom
Facebook – R Programming Group for Discussions & Questions:   / statisticsglobe
Facebook – Python Programming Group for Discussions & Questions:   / statisticsglobepython
LinkedIn – Statistics Globe Page:   / statisticsglobe
LinkedIn – R Programming Group for Discussions & Questions:   / 12555223
LinkedIn – Python Programming Group for Discussions & Questions:   / 12673534
Twitter:   / joachimschork

Music by bensound.com