1 python讀取 excel
?data= xlrd.open_workbook('/home/Desktop/批量升級(jí).xlsx')
???table = data.sheets()[0]
???ncols = table.ncols
???rt_list = table.col_values(0)
???rt_list = [i.encode('utf-8') for i in rt_list]
2 寫excel
主要代碼如下：
from pandas import DataFrame
data={
'name':['張三','李四','王五'],
'age':[11,12,13]
'sex':'男','女','男']
}
df=DataFrame(data)
df.to_excel('new.xlsx",sheet_name='XXX')
3 pandas df filter
# 每5min采樣
df = df[df.apply(lambda x:int(str(x['timestamp'])[-5:-3])/5==0,axis=1)]
