# -*- coding: utf-8 -*-
"""
Created on Wed May 22 15:26:28 2019
@author: User
"""
import pandas as pd
print('\n使用字典创建DataFram')
dfdata={'Name':['Zhang San','Li Si','Wang Wu','Zhao Liu','Qian Qi','Sun Ba'],
'Subject':['Literature','History','English','Maths','Physics','Chemics'],
'Score':[98,76,84,70,93,83]}
scoresheet=pd.DataFrame(dfdata)
print(scoresheet)
print('\n')
print('\n scoresheet.head():')
print(scoresheet.head(3))
print('\n scoresheet.columns:')
print(scoresheet.columns)
print('\n scoresheet.values:')
print(scoresheet.values)
print('\n使用嵌套字典创建DataFram-------------------')
dfdata2={'Name':{101:'Zhang San',102:'Li Si',103:'Wang Wu',104:'Zhao Liu',105:'Qian Qi',106:'Sun Ba'},
'Subject':{101:'Literature',102:'History',103:'English',104:'Maths',105:'Physics',106:'Chemics'},
'Score':{101:98,102:76,103:84,104:70,105:93,106:83}
}
scoresheet2=pd.DataFrame(dfdata2)
print(scoresheet2)
print('\n 每列都是一个Series:')
print(scoresheet2.Score)
运行：
使用字典创建DataFram Name Subject Score 0 Zhang San Literature 98 1 Li Si History 76 2 Wang Wu English 84 3 Zhao Liu Maths 70 4 Qian Qi Physics 93 5 Sun Ba Chemics 83
scoresheet.head(): Name Subject Score 0 Zhang San Literature 98 1 Li Si History 76 2 Wang Wu English 84
scoresheet.columns: Index(['Name', 'Subject', 'Score'], dtype='object')
scoresheet.values: [['Zhang San' 'Literature' 98] ['Li Si' 'History' 76] ['Wang Wu' 'English' 84] ['Zhao Liu' 'Maths' 70] ['Qian Qi' 'Physics' 93] ['Sun Ba' 'Chemics' 83]]
使用嵌套字典创建DataFram------------------- Name Subject Score 101 Zhang San Literature 98 102 Li Si History 76 103 Wang Wu English 84 104 Zhao Liu Maths 70 105 Qian Qi Physics 93 106 Sun Ba Chemics 83
每列都是一个Series: 101 98 102 76 103 84 104 70 105 93 106 83 Name: Score, dtype: int64
