Pandas set Index on multiple columns
Multiple Indexing:
import pandas as pd employees = pd.DataFrame({ 'EmpCode': ['Emp001', 'Emp002', 'Emp003', 'Emp004', 'Emp005'], 'Name': ['John', 'Doe', 'William', 'Spark', 'Mark'], 'Occupation': ['Chemist', 'Statistician', 'Statistician', 'Statistician', 'Programmer'], 'Date Of Join': ['2018-01-25', '2018-01-26', '2018-01-26', '2018-02-26', '2018-03-16'], 'Age': [23, 24, 34, 29, 40]}) print("\n --------- Before Index ----------- \n") print(employees) print("\n --------- Multiple Indexing ----------- \n") print(employees.set_index(['Occupation', 'Age']))
C:\pandas>python example.py Date Of Join EmpCode Name Occupation Age Chemist 23 2018-01-25 Emp001 John Statistician 24 2018-01-26 Emp002 Doe 34 2018-01-26 Emp003 William 29 2018-02-26 Emp004 Spark Programmer 40 2018-03-16 Emp005 Mark C:\pandas>
2018-10-17T23:11:59+05:30
2018-10-17T23:11:59+05:30
Amit Arora
Amit Arora
Python Programming Tutorial
Python
Practical Solution