# Pandas Excel: Draw a bar plot, where each bar will represent one of the top 10 production

## Pandas: Excel Exercise-23 with Solution

Write a Pandas program to import given excel data (coalpublic2013.xlsx) into a dataframe and draw a bar plot where each bar will represent one of the top 10 production. Go to Excel data

**Sample Solution:**

**Python Code :**

```
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
df = pd.read_excel('E:\coalpublic2013.xlsx')
sorted_by_production = df.sort_values(['Production'], ascending=False).head(10)
sorted_by_production['Production'].head(10).plot(kind="barh")
plt.show()
```

Sample Output:

**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 three datasheets from a given excel data (coalpublic2013.xlsx ) into a single dataframe.

**Next:** Write a Pandas program to import given excel data (coalpublic2013.xlsx ) into a dataframe and draw a bar plot comparing year, MSHA ID, Production and Labor_hours of first ten records.

**What is the difficulty level of this exercise?**

Test your Programming skills with w3resource's quiz.

## Python: Tips of the Day

**Memory Footprint Of An Object:**

import sys x = 'farhadmalik' print(sys.getsizeof(x))

60

**Weekly Trends**- Python Interview Questions and Answers: Comprehensive Guide
- Scala Exercises, Practice, Solution
- Kotlin Exercises practice with solution
- MongoDB Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - JOINS
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- JavaScript String Exercises
- JavaScript HTML Form Validation
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join

We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook