Pandas Excel: Find details where "Mine Name" starts with "P"
12. Find Records Where Mine Name Starts with "P"
Write a Pandas program to import given excel data (coalpublic2013.xlsx ) into a dataframe and find details where "Mine Name" starts with "P". 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["Mine_Name"].map(lambda x: x.startswith('P'))].head()
Sample Output:
Year MSHA ID Mine_Name Production Labor_Hours
13 2013 103332 Powhatan Mine 140521 61394
18 2013 102976 Piney Woods Preparation Plant 0 14828
19 2013 102976 Piney Woods Preparation Plant 0 23193
46 2013 103321 Poplar Springs 189370 76366
Excel Data:
coalpublic2013.xlsx:
For more Practice: Solve these Related Problems:
- Write a Pandas program to import coalpublic2013.xlsx and filter the DataFrame for rows where "Mine Name" begins with the letter "P".
- Write a Pandas program to use string methods on the "Mine Name" column and select records starting with "P".
- Write a Pandas program to filter coalpublic2013.xlsx data for mines with names that match a regex pattern beginning with "P".
- Write a Pandas program to extract and display all records from the Excel file where the "Mine Name" column starts with "P".
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 details where 'Labor Hours' > 20000.
Next: Write a Pandas program to import given excel data (coalpublic2013.xlsx) into a dataframe and find all records that include two specific MSHA ID.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.