import pandas as pd
# load excel file
path_load = 'D:/columntest.xlsx'
xlsx = pd.ExcelFile(path)
df = pd.read_excel(path, sheet_name=0, header=None)
# store sheet as csv file
path_store = path_load[:-5] + '.csv'
df.to_csv(path_store, sep=';', index=False, header=False)
# process csv to remove lines with `;;`
with open(path_store, "r") as f:
lines = f.readlines()
with open(path_store, "w") as f:
for line in lines:
if line.strip("\n") != ';;':
f.write(line)
df = pd.read_csv(path_store, sep=';')
此解决方案的思想是将excel工作表加载到数据框中。然后将其存储到csv文件中。最后,我们打开csv文件并删除带有双分号的所有行
您可以使用drop_na方法:
相关问题 更多 >
编程相关推荐