import pandas as pd
import numpy as np
1、读取文件
data = pd.read_excel(path)
2、新建一个xlsx文件并写入一个dataframe
writer = pd.ExcelWriter("/home/kesai/inceptio/projects_server/zhenqi/20220428/dms-server_backup/frequency_video_2022-03-31_1.xlsx")
temp = []
for path in all_path.glob("**/*"):
path = str(path)
if path.endswith('.mp4'):
url_path = path
results = tis_infer(url_path, mode='oracle')
print(results[0]['FREQ'])
temp.append([path, results[0]['FREQ']])
df = pd.DataFrame(data=temp, columns=['videos', 'freq score'])
df.to_excel(writer, sheet_name='Sheet1', index=False)
writer.save()
3、判断某个单元格是否为空
for i,rows in data.iterrows():
print(type(data.loc[i,'在读']) == float)
print(data.loc[i,'在读']is np.nan)
4、读取行数及索引
print(len(df.index.values))
print(df.index.values)
print(len(df.columns.values))
print(df.columns.values)
data = df.loc[0].values
data = df.loc[[1, 2]].values
data = df.iloc[0].values
data = df.iloc[[1, 2]].values