new.py

# -*- coding: utf-8 -*-
"""
Created on Sat Sep 16 00:46:29 2017

@author: nasa
"""

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt


rawdata=pd.read_excel('rawdata.xls')
rawdata1=rawdata.drop(range(14))
rawdata1.columns=['current','voltage','power','speed','torque']
#ef=pd.read_excel('2.xls')
#print(sf.head())
#print(sf['專案代號'])
#pm=sf['專案代號']
#my_data=sf['專案代號'].append(ef['專案代號'])

#刪除表格中重複的專案代號
#df=sf.drop_duplicates(['專案代號'])
#df=my_data.drop_duplicates()

#df=pd.read.excel('20161108.xls')
#刪除index存檔
#df.to_csv('project.csv',index=False)
#看欄位名稱
#print(df.columns)
#print(df.loc[:,['專案狀態','專案代號']])
#print(rawdata1)
eff=(rawdata1['torque']*9.81/100/1000*rawdata1['speed']*2*np.pi/60)/(rawdata1['current']*rawdata1['voltage'])*100
#print(eff)

#plot curve
plt.plot(rawdata1['torque'],rawdata1['speed'],'ro')
plt2=plt.twinx()#雙座標
plt2.plot(rawdata1['torque'],eff,'b')
#plt.legend(['location','time'])
#plt.xlabel('L')
#plt.ylabel('t')
#plt.savefig('myplot.png')
plt.show()

#fftraw=pd.read_excel('fft.xls')
#xf=np.fft.fft(fftraw)