zxy0307's picture
Upload 141 files
593040d verified
raw
history blame contribute delete
822 Bytes
"""
pd.DataFrame(data, index, columns, dtype)
data: 数据
index: 行索引
columns: 列索引
dtype: 数据类型
"""
import pandas as pd
# 列表方式创建DataFrame对象
data = [['小太阳', 320.9, 100], ['鼠标', 150.3, 50], ['小刀', 1.5, 200]]
columns = ['名称', '单价', '数量']
df = pd.DataFrame(data=data, columns=columns)
print(df)
print(type(df))
# 字典方式创建DataFrame对象 -- 要求列表长度一致
data = {
'名称': ['小太阳', '鼠标', '小刀'],
'单价': [320.9, 150.3, 1.5],
'数量': [100, 50, 200]
}
df = pd.DataFrame(data=data)
print(df)
# 自动填充
data = {
'名称': ['小太阳', '鼠标', '小刀'],
'单价': [320.9, 150.3, 1.5],
'数量': [100, 50, 200],
'公司': '东门超市'
}
df = pd.DataFrame(data=data)
print(df)