Python-科学计算-pandas-15-df输出Excel和解析Excel

<pre class="brush:php;toolbar:false;">import pandas as pdimport osdict_1 = {"time": ["2019-11-02", "2019-11-03", "2019-11-04", "2019-11-05",                   "2019-12-02", "2019-12-03", "2019-12-04", "2019-12-05"],          "pos": ["A", "A", "B", "B", "C", "C", "C", "D"],          "value1": [10, 20, 30, 40, 50, 60, 70, 80]}df_1 = pd.DataFrame(dict_1, columns=["time", "pos", "value1"])print("原数据", "\n", df_1, "\n")# 输出到Excelcurrent_address = os.path.dirname(os.path.abspath(__file__))excel_name = "df.xlsx"excel_address = os.path.join(current_address, excel_name)df_1.to_excel(excel_address)excel_name_2 = "df_2.xlsx"excel_address_2 = os.path.join(current_address, excel_name_2)df_2 = df_1.head(3)df_2.to_excel(excel_address_2)# 读Excel数据df_3 = pd.read_excel(excel_address)print(df_3)excel_name_4 = "test.xlsx"excel_address_4 = os.path.join(current_address, excel_name_4)df_4 = pd.read_excel(excel_address_4, sheetname="ceshi", header=0)print(df_4)

df_1.to_excel(excel_address)

df_2 = df_1.head(3)

df_3 = pd.read_excel(excel_address)

sheetname="ceshi"

df_4 = pd.read_excel(excel_address_4, sheetname="ceshi", header=0)