Pandas（二） 

# 打印所有结果
from IPython.core.interactiveshell import InteractiveShell
InteractiveShell.ast_node_interactivity = "all"

import pandas as pd

1. 从文件读

# 【1】从剪切板上读取 - 方便，适用于演示、数据量小的数据读取
BSdata = pd.read_clipboard();
BSdata
Region/Country/Area Unnamed: 1 Year Series Value Footnotes
0 1 Total, all countries or areas 2010 Population mid-year estimates (millions) 6,956.82 NaN
1 1 Total, all countries or areas 2010 Population mid-year estimates for males (milli... 3,507.70 NaN
2 1 Total, all countries or areas 2010 Population mid-year estimates for females (mil... 3,449.12 NaN
3 1 Total, all countries or areas 2010 Sex ratio (males per 100 females) 101.7 NaN
4 1 Total, all countries or areas 2010 Population aged 0 to 14 years old (percentage) 27 NaN
5 1 Total, all countries or areas 2010 Population aged 60+ years old (percentage) 11 NaN
6 1 Total, all countries or areas 2010 Population density 53.5 NaN
7 1 Total, all countries or areas 2015 Population mid-year estimates (millions) 7,379.80 NaN
8 1 Total, all countries or areas 2015 Population mid-year estimates for males (milli... 3,720.70 NaN
9 1 Total, all countries or areas 2015 Population mid-year estimates for females (mil... 3,659.10 NaN
10 1 Total, all countries or areas 2015 Sex ratio (males per 100 females) 101.7 NaN
11 1 Total, all countries or areas 2015 Population aged 0 to 14 years old (percentage) 26.2 NaN
12 1 Total, all countries or areas 2015 Population aged 60+ years old (percentage) 12.2 NaN
13 1 Total, all countries or areas 2015 Population density 56.7 NaN
14 1 Total, all countries or areas 2015 Surface area (thousand km2) 136,162 NaN
15 1 Total, all countries or areas 2019 Population mid-year estimates (millions) 7,713.47 NaN
16 1 Total, all countries or areas 2019 Population mid-year estimates for males (milli... 3,889.03 NaN 
# 【2】读取 csv 数据 - csv是文本文件，以逗号做分隔 - 常用
BSdata = pd.read_csv("data/test.csv", encoding="utf-8") #GBK
BSdata.head() # head()取数据头5条
Region/Country/Area Unnamed: 1 Year Series Value Footnotes Source
0 1.0 Total, all countries or areas 2010.0 Population mid-year estimates (millions) 6,956.82 NaN United Nations Population Division, New York, ...
1 1.0 Total, all countries or areas 2010.0 Population mid-year estimates for males (milli... 3,507.70 NaN United Nations Population Division, New York, ...
2 1.0 Total, all countries or areas 2010.0 Population mid-year estimates for females (mil... 3,449.12 NaN United Nations Population Division, New York, ...
3 1.0 Total, all countries or areas 2010.0 Sex ratio (males per 100 females) 101.7 NaN United Nations Population Division, New York, ...
4 1.0 Total, all countries or areas 2010.0 Population aged 0 to 14 years old (percentage) 27 NaN United Nations Population Division, New York, ... 
# 【3】读取 Excel 格式数据 - 推荐！！ 中英文识别好
BSdata = pd.read_excel("data/test.xlsx", 'BSdata') # 读取test.xlsx中BSdata表单中的数据
BSdata
Region/Country/Area Unnamed: 1 Year Series Value Footnotes Source
0 1 Total, all countries or areas 2010 Population mid-year estimates (millions) 6956.82 NaN United Nations Population Division, New York, ...
1 1 Total, all countries or areas 2010 Population mid-year estimates for males (milli... 3507.70 NaN United Nations Population Division, New York, ...
2 1 Total, all countries or areas 2010 Population mid-year estimates for females (mil... 3449.12 NaN United Nations Population Division, New York, ...
3 1 Total, all countries or areas 2010 Sex ratio (males per 100 females) 101.70 NaN United Nations Population Division, New York, ...
4 1 Total, all countries or areas 2010 Population aged 0 to 14 years old (percentage) 27.00 NaN United Nations Population Division, New York, ...
5 1 Total, all countries or areas 2010 Population aged 60+ years old (percentage) 11.00 NaN United Nations Population Division, New York, ...
6 1 Total, all countries or areas 2010 Population density 53.50 NaN United Nations Population Division, New York, ...
7 1 Total, all countries or areas 2015 Population mid-year estimates (millions) 7379.80 NaN United Nations Population Division, New York, ...
8 1 Total, all countries or areas 2015 Population mid-year estimates for males (milli... 3720.70 NaN United Nations Population Division, New York, ...
9 1 Total, all countries or areas 2015 Population mid-year estimates for females (mil... 3659.10 NaN United Nations Population Division, New York, ...
10 1 Total, all countries or areas 2015 Sex ratio (males per 100 females) 101.70 NaN United Nations Population Division, New York, ...
11 1 Total, all countries or areas 2015 Population aged 0 to 14 years old (percentage) 26.20 NaN United Nations Population Division, New York, ...
12 1 Total, all countries or areas 2015 Population aged 60+ years old (percentage) 12.20 NaN United Nations Population Division, New York, ...
13 1 Total, all countries or areas 2015 Population density 56.70 NaN United Nations Population Division, New York, ...
14 1 Total, all countries or areas 2015 Surface area (thousand km2) 136162.00 NaN United Nations Statistics Division, New York, ...
15 1 Total, all countries or areas 2019 Population mid-year estimates (millions) 7713.47 NaN United Nations Population Division, New York, ...
16 1 Total, all countries or areas 2019 Population mid-year estimates for males (milli... 3889.03 NaN United Nations Population Division, New York, ...
17 1 Total, all countries or areas 2019 Population mid-year estimates for females (mil... 3824.43 NaN United Nations Population Division, New York, ...
18 1 Total, all countries or areas 2019 Sex ratio (males per 100 females) 101.70 NaN United Nations Population Division, New York, ...
19 1 Total, all countries or areas 2019 Population aged 0 to 14 years old (percentage) 25.60 NaN United Nations Population Division, New York, ...
20 1 Total, all countries or areas 2019 Population aged 60+ years old (percentage) 13.20 NaN United Nations Population Division, New York, ...
21 1 Total, all countries or areas 2019 Population density 59.30 NaN United Nations Population Division, New York, ...
22 1 Total, all countries or areas 2019 Surface area (thousand km2) 130094.00 NaN United Nations Statistics Division, New York, ...
23 1 Total, all countries or areas 2021 Population mid-year estimates (millions) 7874.97 Projected estimate (medium fertility variant). United Nations Population Division, New York, ...
24 1 Total, all countries or areas 2021 Population mid-year estimates for males (milli... 3970.24 Projected estimate (medium fertility variant). United Nations Population Division, New York, ...

2. 保存数据到文件

# 【1】保存为csv格式
BSdata.to_csv('data/BSdata.csv')

# 【2】保存到Excel文件中
BSdata.to_excel('data/BSdata.xlsx',index = False)# index=False 表示不保存行标签 - 默认为True
posted @ 2022-09-27 19:26  LUNA2333  阅读(52)  评论(0)    收藏  举报