Pandas Excel: Convert the data to use the hire_date as the index
19. Set Hire Date as Index
Write a Pandas program to import given excel data (employee.xlsx ) into a Pandas dataframe and convert the data to use the hire_date as the index. Go to Excel data
Sample Solution:
Python Code :
import pandas as pd
import numpy as np
df = pd.read_excel('E:\employee.xlsx')
result = df.set_index(['hire_date'])
result
Sample Output:
emp_id first_name last_name
hire_date
2003-06-17 100 Steven King
2005-09-21 101 Neena Kochhar
2001-01-13 102 Lex De Haan
2006-01-03 103 Alexander Hunold
2007-05-21 104 Bruce Ernst
2005-06-25 105 David Austin
2006-02-05 106 Valli Pataballa
2007-02-07 107 Diana Lorentz
2002-08-17 108 Nancy Greenberg
2002-08-16 109 Daniel Faviet
2005-09-28 110 John Chen
2005-09-30 111 Ismael Sciarra
2006-03-07 112 Jose Manuel Urman
2007-12-07 113 Luis Popp
2002-12-07 114 Den Raphaely
2003-05-18 115 Alexander Khoo
2005-12-24 116 Shelli Baida
2005-07-24 117 Sigal Tobias
2006-11-15 118 Guy Himuro
2007-08-10 119 Karen Colmenares
Excel Data:
employee.xlsx:
Sheet-1
Sheet-2
Sheet-3
For more Practice: Solve these Related Problems:
- Write a Pandas program to import employee.xlsx and set the hire_date column as the DataFrame index.
- Write a Pandas program to convert the hire_date column to datetime and then assign it as the index for the employee DataFrame.
- Write a Pandas program to reindex the employee DataFrame using the hire_date column and then display the new index.
- Write a Pandas program to set the hire_date as the index and then sort the DataFrame by this new index.
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to import given excel data (employee.xlsx ) into a Pandas dataframe and find a list of employees of a specified year.
Next: Write a Pandas program to import given excel data (employee.xlsx ) into a Pandas dataframe and sort based on multiple given columns.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.