import pandas as pd df = pd.read_excel(r'temp.xlsx', sheet_name=0) 1. 2. 读取指定列数据 代码如下: import pandas as pd df = pd.read_excel(r'temp.xlsx', sheet_name=0, usecols=[0, 2]) print(df) 1. 2. 3. 4. 二、DataFrame转化为json DataFrame.to_json参数说明 DataFrame.to_js...
import pandas as pddf = pd.read_excel(r'temp.xlsx', sheet_name=0) 读取指定列数据 代码如下: import pandas as pddf = pd.read_excel(r'temp.xlsx', sheet_name=0, usecols=[0, 2])print(df) 二、DataFrame转化为json DataFrame.to_json参数说明 DataFrame.to_json(path_or_buf=None, orient=N...