Requirement already satisfied: xlrd==2.0.1 in /root/venv/lib/python3.7/site-packages (2.0.1)
WARNING: You are using pip version 20.1.1; however, version 21.0.1 is available.
You should consider upgrading via the '/root/venv/bin/python -m pip install --upgrade pip' command.
Requirement already satisfied: openpyxl==3.0.6 in /root/venv/lib/python3.7/site-packages (3.0.6)
Requirement already satisfied: jdcal in /root/venv/lib/python3.7/site-packages (from openpyxl==3.0.6) (1.4.1)
Requirement already satisfied: et-xmlfile in /root/venv/lib/python3.7/site-packages (from openpyxl==3.0.6) (1.0.1)
WARNING: You are using pip version 20.1.1; however, version 21.0.1 is available.
You should consider upgrading via the '/root/venv/bin/python -m pip install --upgrade pip' command.
Requirement already satisfied: xlwt==1.3.0 in /root/venv/lib/python3.7/site-packages (1.3.0)
WARNING: You are using pip version 20.1.1; however, version 21.0.1 is available.
You should consider upgrading via the '/root/venv/bin/python -m pip install --upgrade pip' command.
#file_path = "order.亚马逊跟踪号_20210130.xls"
#/work/daily/order.亚马逊跟踪号_20210130.xls
path_list = os.listdir("/work/daily")
path_list = [r"/work/daily/"+ _ for _ in path_list]
path_list.sort()
print(path_list)
#path_list = ["order.亚马逊跟踪号_20210130.xls","order.亚马逊跟踪号_20210131.xls","order.亚马逊跟踪号_20210201.xls","order.亚马逊跟踪号_20210202.xls"]
def read_daily(file_path):
df = pd.read_excel(file_path)
# date_parser = "openpyxl"
asian_cell = df["salesRecordNumber"]
daily_date = file_path[-12:-4]
daily_count = pd.DataFrame()
daily_count[daily_date] = asian_cell.value_counts()
daily_count_list.append(daily_count)
daily_count_list = []
for file_path in path_list:
read_daily(file_path)
df_1 = pd.concat(daily_count_list,axis = 1).fillna(0)
df_2 = pd.DataFrame(df_1.values.T, index=df_1.columns, columns=df_1.index)
df_2
#pd.concat(daily_count_list,axis = 1).to_excel("new.xls")
['/work/daily/order.亚马逊跟踪号_20210130.xls', '/work/daily/order.亚马逊跟踪号_20210131.xls', '/work/daily/order.亚马逊跟踪号_20210201.xls', '/work/daily/order.亚马逊跟踪号_20210202.xls']
df_2.plot(figsize = (20,10)).legend(bbox_to_anchor=(1.01, 1), loc=2, borderaxespad=0)