Pandas Excel: Find details where "Mine Name" starts with "P"
Pandas: Excel Exercise-12 with Solution
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:
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.
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-12.php
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics