w3resource

Pandas Excel: Convert the data to use the hire_date as the 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


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.



Follow us on Facebook and Twitter for latest update.