In [29]:

    

%matplotlib inline
import pandas as pd
import seaborn as sns
import numpy as np
df=pd.read_excel("sb.xls")
import matplotlib.pyplot as plt


    

In [21]:

    

sbsa = df[df['name']=='SBSA']
labels=np.array(sbsa['label'].values)


    

In [34]:

    

stats=sbsa['value'].values

angles=np.linspace(0, 2*np.pi, len(labels), endpoint=False)
# close the plot
stats=np.concatenate((stats,[stats[0]]))
angles=np.concatenate((angles,[angles[0]]))

fig=plt.figure()
ax = fig.add_subplot(111, polar=True)
ax.plot(angles, stats, 'o-', linewidth=2)
ax.fill(angles, stats, alpha=0.25)
ax.set_thetagrids(angles * 180/np.pi, labels)
ax.set_title('Bank A \n')
ax.grid(True)
plt.show()