python笔记：3.2.1.1pandas数据结构_DataFrame

# -*- 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