Pandas Excel: Sort the records by the hire_date column
Pandas: Excel Exercise-16 with Solution
Write a Pandas program to import given excel data (employee.xlsx ) into a Pandas dataframe and to sort the records by the hire_date column. 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.sort_values('hire_date')
result
Sample Output:
emp_id first_name last_name hire_date 2 102 Lex De Haan 2001-01-13 9 109 Daniel Faviet 2002-08-16 8 108 Nancy Greenberg 2002-08-17 14 114 Den Raphaely 2002-12-07 15 115 Alexander Khoo 2003-05-18 0 100 Steven King 2003-06-17 5 105 David Austin 2005-06-25 17 117 Sigal Tobias 2005-07-24 1 101 Neena Kochhar 2005-09-21 10 110 John Chen 2005-09-28 11 111 Ismael Sciarra 2005-09-30 16 116 Shelli Baida 2005-12-24 3 103 Alexander Hunold 2006-01-03 6 106 Valli Pataballa 2006-02-05 12 112 Jose Manuel Urman 2006-03-07 18 118 Guy Himuro 2006-11-15 7 107 Diana Lorentz 2007-02-07 4 104 Bruce Ernst 2007-05-21 19 119 Karen Colmenares 2007-08-10 13 113 Luis Popp 2007-12-07
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 where hire_date> 01-01-07.
Next: Write a Pandas program to import given excel data (employee.xlsx ) into a Pandas dataframe and find a list of employees where hire_date between two specific month and year.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
It will be nice if you may share this link in any developer community or anywhere else, from where other developers may find this content. Thanks.
https://www.w3resource.com/python-exercises/pandas/excel/python-pandas-excel-exercise-16.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics