İmport Excel Data in Python

import xlrd
import matplotlib.pyplot as plt

workbook = xlrd.open_workbook('C:\Users\pc\Desktop\Kitap2.xls')

workbook.nsheets

sheet=workbook.sheet_by_index(0)

a=[sheet.cell_value(rowx=i, colx=0) for i in range(sheet.nrows)]

plt.plot(a)

Data Analysis in Python-Descriptive Statistics

# -*- coding: utf-8 -*-

import numpy as np
import matplotlib.pyplot as plt

data1=[85,62,78,64,25,12,74,96,63,45,78,20,5,30,45,78,45,96,65,45,74,12,78,23,8]
# create a data

mean=np.mean(data1) 
#data mean

variance=np.var(data1)
#data variance

standartdev=np.std(data1)
#data standart deviation

max=np.max(data1)
# biggest number of data1

min=np.min(data1)
#smallest number of data1

percentiles=numpy.percentile(data1,25)
#percentiles of data1 # we find percentile 25


plt.plot(data1)
plt.show() 
plt.pie(data1)   
plt.show()

# we show graph of data1 #pie and plot