Python : pandas基础（一）

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”)