- 通过字典创建DataFrame
# 导入库
import pandas as pd
import numpy as np
#字典数据
city_data = {
'city': ['new york city', 'Pairs', 'Rome'],
'country': ['USA', 'France', 'Italy'],
'population': [8600000, 2141000, 2873000]
}
cities = pd.DataFrame(city_data)
cities
# 内容转置,下面2条代码等效
cities.T
cities.transpose()
2. 通过ndarray创建DataFrame
arr = np.random.randint(1,101,(4,5))
pd.DataFrame(arr)
# index,columns 设置行、列名称
row_labals = ['A', 'B', 'C', 'D']
col_labals = ['mon', 'tue', 'wed', 'thu', 'fri']
pd.DataFrame(arr, index= row_labals, columns=col_labals)
行、列名称允许出现重复,如:row_labals = [‘A’, ‘B’, ‘C’, ‘A’]
3. 使用read_csv函数导入DataFrame
# parse_dates 字符串转化datetime格式
nba = pd.read_csv('nba.csv', parse_dates=['Birthday'])