To install the package pandas write a python program to calculate the mean and standard deviation for list of numbers stored in excel file named data.xlsx.(Use JupyterNotebook or Spyder tool in Anaconda Navigator)

-

 import pandas

af=pandas.read_excel("d:\\data.xlsx")

print(af)

print(af.mean())

print(af.std())

Comments

Post a Comment

Popular posts from this blog

Write a python program to compute cumulative product of a list of numbers (write function cumulative_product).

-
 def cummulative_product(n):     l=[]     product=1     print("Read The List Of Elements Upto:",n)     for i in range(n):         ele=int(input())         l.append(ele)     for i in l:         product=product*i     return product n=int(input("Enter Size Of List:")) print("The Cummulative Product Of The List is:",cummulative_product(n))               
Read more

Write a Python program to compute distance between two points taking input from the user. Formula for Pythagorean theorem for compute distance between two points is:

-
1)b)Write a Python program to compute distance between two points taking input from the user. Formula for Pythagorean theorem for compute distance between two points is:   n1=int(input("Enter the value of point 1_ x-axis")) n2=int(input("Enter the value of point 1_y-axis")) n3=int(input("Enter the value of point 2 _x-axis ")) n4=int(input("Enter the value of point 2_y-axis")) distance=(((n3-n1)**2)+((n4-n2)**2))**(0.5) print("The distance for the given two cartesian points   are ",distance)
Read more