Pandas
- 读取文件
import pandas as pd
import numpy as np
import os
# set the work directory (personal setting)
os.chdir("XXX")
# read the file
data = pd.read_excel(personal_path)
data = pd.read_csv(personal_path)
# set the type of one column
data = pd.read_excel(personal_path, dtype = {"trade_date":np.int32})
- DataFrame常用操作
# column content split
df1 = df['address'].str.split(' ', expand=True)