import pandas as pd
import numpy as np
引入数据
xx=r"D:\lx-numpy\xs1.xlsx"
a=pd.read_excel(xx)
print(a.head(10))
Series函数
s = pd.Series([1,2,3,5,np.nan,8,13])
print(s)
DataFrame函数
df = pd.DataFrame(np.random.randn(3,4),columns=[“a”,“b”,“c”,“d”])
print(df)
导出EXCEL
a.to_excel(“excel_to_python.xlsx”, sheet_name=“bluewhale_cc”)