Answer:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
df = pd.read_excel('coalpublic2013.xlsx')
sorted_by_production = df.sort_values(['Production'], ascending=False).head(10)
sorted_by_production['Production'].head(10).plot(kind="bar")
plt.show()
Explanation:
The python program plot a bar chart of the top ten productions in the excel worksheet. The excel file is read in as a pandas dataframe, sorted in descending order and the first ten of the dataframe is plotted as a bar plot.
