Pandas Excel: Find details where 'Labor Hours' greater than a specific number
11. Filter Records with Labor Hours > 20000
Write a Pandas program to import given excel data (coalpublic2013.xlsx) into a dataframe and find details where 'Labor Hours' > 20000. Go to Excel data
Sample Solution:
Python Code :
import pandas as pd
import numpy as np
df = pd.read_excel('E:\coalpublic2013.xlsx')
df[df["Labor_Hours"] > 20000].head()
Sample Output:
Year MSHA ID Mine_Name Production Labor_Hours 0 2013 103381 Tacoa Highwall Miner 56004 22392 1 2013 103404 Reid School Mine 28807 28447 2 2013 100759 North River #1 Underground Min 1440115 474784 3 2013 103246 Bear Creek 87587 29193 4 2013 103451 Knight Mine 147499 46393
Excel Data:
coalpublic2013.xlsx:
For more Practice: Solve these Related Problems:
- Write a Pandas program to import coalpublic2013.xlsx and filter rows where "Labor Hours" exceed 20000.
- Write a Pandas program to display records from the Excel data that satisfy the condition Labor Hours > 20000.
- Write a Pandas program to use conditional selection to extract rows with "Labor Hours" greater than 20000.
- Write a Pandas program to filter and print the details of mines with Labor Hours above 20000 from the DataFrame.
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to import given excel data (coalpublic2013.xlsx ) into a dataframe and find a specific MSHA ID.
Next: Write a Pandas program to import given excel data (coalpublic2013.xlsx ) into a dataframe and find details where "Mine Name" starts with "P".
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.