pandas数据筛选及过滤、字符串提取与操作、画图

最新推荐文章于 2024-07-28 08:00:00 发布

songhao8080

最新推荐文章于 2024-07-28 08:00:00 发布

阅读量1k

点赞数

本文链接：https://blog.csdn.net/songhao8080/article/details/103670344

版权

1、pandas 库之数据筛选及过滤：
主要介绍 pandas 库的用途，以及安装方法。并介绍它的用途，包括数据的选择和筛选。
 
2、pandas 库之字符串提取与操作：
本课时主要介绍使用 pandas 库进行字符串数据的提取与其他操作，使得 pandas 库可以操作字符串数据。
 
3、pandas 库之散点图：
本课时主要介绍使用 pandas 绘制散点图以及轨迹的方法，通过pandas库也可以绘制图形。
 
4、pandas 库之直方图：
本课时主要介绍使用 pandas 绘制直方图，柱形图和箱形图的方法。

In [278]:

Python

''' 第一节： #pandas 库之数据筛选及过滤 ************************************ '''

'''

第一节：

#pandas 库之数据筛选及过滤 ************************************

'''

Out[278]:

Python

'\n\n\xe7\xac\xac\xe4\xb8\x80\xe8\x8a\x82\xef\xbc\x9a\n#pandas \xe5\xba\x93\xe4\xb9\x8b\xe6\x95\xb0\xe6\x8d\xae\xe7\xad\x9b\xe9\x80\x89\xe5\x8f\x8a\xe8\xbf\x87\xe6\xbb\xa4 ************************************\n\n'

1	'\n\n\xe7\xac\xac\xe4\xb8\x80\xe8\x8a\x82\xef\xbc\x9a\n#pandas \xe5\xba\x93\xe4\xb9\x8b\xe6\x95\xb0\xe6\x8d\xae\xe7\xad\x9b\xe9\x80\x89\xe5\x8f\x8a\xe8\xbf\x87\xe6\xbb\xa4 ************************************\n\n'

In [3]:

Python

import pandas as pd import numpy as np import matplotlib.pyplot as plt dates = pd.date_range('20160715',periods=6) dates

import pandas as pd

import numpy as np

import matplotlib . pyplot as plt

dates = pd . date_range ( '20160715' , periods = 6 )

dates

Out[3]:

Python

DatetimeIndex(['2016-07-15', '2016-07-16', '2016-07-17', '2016-07-18', '2016-07-19', '2016-07-20'], dtype='datetime64[ns]', freq='D', tz=None)

DatetimeIndex ( [ '2016-07-15' , '2016-07-16' , '2016-07-17' , '2016-07-18' ,

'2016-07-19' , '2016-07-20' ] ,

dtype = 'datetime64[ns]' , freq = 'D' , tz = None )

In [115]:

Python

df = pd.DataFrame(np.random.rand(6,4),index=dates,columns=list('ABCD')) df

df = pd . DataFrame ( np . random . rand ( 6 , 4 ) , index = dates , columns = list ( 'ABCD' ) )

df

Out[115]:

	A	B	C	D
2016-07-15	0.257509	0.264885	0.540292	0.485975
2016-07-16	0.629827	0.079777	0.338386	0.187553
2016-07-17	0.375727	0.700579	0.384695	0.909140
2016-07-18	0.418069	0.308024	0.451242	0.758287
2016-07-19	0.114625	0.397367	0.888026	0.358038
2016-07-20	0.454836	0.182236	0.158715	0.002074

In [12]:

Python

df2 = pd.DataFrame({'A':np.random.randn(6)})#定义一个随机数字的DF数据表 df2

df2 = pd . DataFrame ( { 'A' : np . random . randn ( 6 ) } ) #定义一个随机数字的DF数据表

df2

Out[12]:

	A
0	-2.058364
1	0.817129
2	1.630002
3	0.673549
4	0.416836
5	0.033933

In [22]:

Python

df['A']#调用A列

1	< span class = "n" > df < / span > < span class = "p" > [ < / span > < span class = "s" > 'A' < / span > < span class = "p" > ] < / span > < span class = "c" > #调用A列</span>

Out[22]:

Python

2016-07-15 0.736079 2016-07-16 0.183782 2016-07-17 0.198436 2016-07-18 0.865754 2016-07-19 0.095199 2016-07-20 0.731607 Freq: D, Name: A, dtype: float64

2016 - 07 - 15 0.736079

2016 - 07 - 16 0.183782

2016 - 07 - 17 0.198436

2016 - 07 - 18 0.865754

2016 - 07 - 19 0.095199

2016 - 07 - 20 0.731607

Freq : D , Name : A , dtype : float64

In [25]:

Python

df[1:3]#调用从1~2的行数

1	< span class = "n" > df < / span > < span class = "p" > [ < / span > < span class = "mi" > 1 < / span > < span class = "p" > : < / span > < span class = "mi" > 3 < / span > < span class = "p" > ] < / span > < span class = "c" > #调用从1~2的行数</span>

Out[25]:

	A	B	C	D
2016-07-16	0.183782	0.740787	0.589655	0.167018
2016-07-17	0.198436	0.452805	0.275851	0.119994

In [27]:

Python

df['20160715':'20160718']#调用时间序列XX~XX时间的数据

1	< span class = "n" > df < / span > < span class = "p" > [ < / span > < span class = "s" > '20160715' < / span > < span class = "p" > : < / span > < span class = "s" > '20160718' < / span > < span class = "p" > ] < / span > < span class = "c" > #调用时间序列XX~XX时间的数据</span>

Out[27]:

	A	B	C	D
2016-07-15	0.736079	0.959340	0.830599	0.627481
2016-07-16	0.183782	0.740787	0.589655	0.167018
2016-07-17	0.198436	0.452805	0.275851	0.119994
2016-07-18	0.865754	0.584943	0.381434	0.966995

In [30]:

Python

df.loc['20160715':'20160718',['A','B']]#.loc是通过标签来切片

df . loc [ '20160715' : '20160718' , [ 'A' , 'B' ] ] #.loc是通过标签来切片

Out[30]:

	A	B
2016-07-15	0.736079	0.959340
2016-07-16	0.183782	0.740787
2016-07-17	0.198436	0.452805
2016-07-18	0.865754	0.584943

In [31]:

Python

df.loc['20160715',['A']]#.loc是通过标签来切片

df . loc [ '20160715' , [ 'A' ] ] #.loc是通过标签来切片

Out[31]:

Python

A 0.736079 Name: 2016-07-15 00:00:00, dtype: float64

1 2	A 0.736079 Name : 2016 - 07 - 15 00 : 00 : 00 , dtype : float64

In [38]:

Python

df.at[dates[0],'B']#.at是通过数据位置来取数

df . at [ dates [ 0 ] , 'B' ] #.at是通过数据位置来取数

Out[38]:

Python

0.95934014640962595

1	0.95934014640962595

In [40]:

Python

df.head(3)#查看前3行

1	< span class = "n" > df < / span > < span class = "o" > . < / span > < span class = "n" > head < / span > < span class = "p" > ( < / span > < span class = "mi" > 3 < / span > < span class = "p" > ) < / span > < span class = "c" > #查看前3行</span>

Out[40]:

	A	B	C	D
2016-07-15	0.736079	0.959340	0.830599	0.627481
2016-07-16	0.183782	0.740787	0.589655	0.167018
2016-07-17	0.198436	0.452805	0.275851	0.119994

In [41]:

Python

df.tail()#默认查看后5行

1	< span class = "n" > df < / span > < span class = "o" > . < / span > < span class = "n" > tail < / span > < span class = "p" > ( ) < / span > < span class = "c" > #默认查看后5行</span>

Out[41]:

	A	B	C	D
2016-07-16	0.183782	0.740787	0.589655	0.167018
2016-07-17	0.198436	0.452805	0.275851	0.119994
2016-07-18	0.865754	0.584943	0.381434	0.966995
2016-07-19	0.095199	0.431479	0.394274	0.041155
2016-07-20	0.731607	0.018931	0.694380	0.189079

In [42]:

Python

df.index#数据表的索引

1	< span class = "n" > df < / span > < span class = "o" > . < / span > < span class = "n" > index < / span > < span class = "c" > #数据表的索引</span>

Out[42]:

Python

DatetimeIndex(['2016-07-15', '2016-07-16', '2016-07-17', '2016-07-18', '2016-07-19', '2016-07-20'], dtype='datetime64[ns]', freq='D', tz=None)

DatetimeIndex ( [ '2016-07-15' , '2016-07-16' , '2016-07-17' , '2016-07-18' ,

'2016-07-19' , '2016-07-20' ] ,

dtype = 'datetime64[ns]' , freq = 'D' , tz = None )

In [43]:

Python

df.columns#查看字段表名

1	< span class = "n" > df < / span > < span class = "o" > . < / span > < span class = "n" > columns < / span > < span class = "c" > #查看字段表名</span>

Out[43]:

Python

Index([u'A', u'B', u'C', u'D'], dtype='object')

1	Index ( [ u 'A' , u 'B' , u 'C' , u 'D' ] , dtype = 'object' )

In [45]:

Python

df.values#查看数据

1	< span class = "n" > df < / span > < span class = "o" > . < / span > < span class = "n" > values < / span > < span class = "c" > #查看数据</span>

Out[45]:

Python

array([[ 0.73607859, 0.95934015, 0.83059865, 0.62748078], [ 0.18378218, 0.74078748, 0.58965485, 0.16701782], [ 0.19843576, 0.4528047 , 0.27585071, 0.1199943 ], [ 0.86575368, 0.58494297, 0.38143413, 0.96699532], [ 0.09519916, 0.43147948, 0.39427373, 0.0411551 ], [ 0.73160684, 0.01893109, 0.69437963, 0.18907934]])

array ( [ [ 0.73607859 , 0.95934015 , 0.83059865 , 0.62748078 ] ,

[ 0.18378218 , 0.74078748 , 0.58965485 , 0.16701782 ] ,

[ 0.19843576 , 0.4528047 , 0.27585071 , 0.1199943 ] ,

[ 0.86575368 , 0.58494297 , 0.38143413 , 0.96699532 ] ,

[ 0.09519916 , 0.43147948 , 0.39427373 , 0.0411551 ] ,

[ 0.73160684 , 0.01893109 , 0.69437963 , 0.18907934 ] ] )

In [46]:

Python

df.describe()#查询表中的描述统计

1	< span class = "n" > df < / span > < span class = "o" > . < / span > < span class = "n" > describe < / span > < span class = "p" > ( ) < / span > < span class = "c" > #查询表中的描述统计</span>

Out[46]:

	A	B	C	D
count	6.000000	6.000000	6.000000	6.000000
mean	0.468476	0.531381	0.527699	0.351954
std	0.344089	0.318945	0.212599	0.364780
min	0.095199	0.018931	0.275851	0.041155
25%	0.187446	0.436811	0.384644	0.131750
50%	0.465021	0.518874	0.491964	0.178049
75%	0.734961	0.701826	0.668198	0.517880
max	0.865754	0.959340	0.830599	0.966995

In [63]:

Python

df.T#反转

1	< span class = "n" > df < / span > < span class = "o" > . < / span > < span class = "n" > T < / span > < span class = "c" > #反转</span>

Out[63]:

	2016-07-15 00:00:00	2016-07-16 00:00:00	2016-07-17 00:00:00	2016-07-18 00:00:00	2016-07-19 00:00:00	2016-07-20 00:00:00
A	0.736079	0.183782	0.198436	0.865754	0.095199	0.731607
B	0.959340	0.740787	0.452805	0.584943	0.431479	0.018931
C	0.830599	0.589655	0.275851	0.381434	0.394274	0.694380
D	0.627481	0.167018	0.119994	0.966995	0.041155	0.189079

In [ ]:

Python

#df2 = pd.DataFrame([1,2,3],index=['a','b','c']) #df2

1 2	< span class = "c" > #df2 = pd.DataFrame([1,2,3],index=['a','b','c'])</span> < span class = "c" > #df2</span>

In [60]:

Python

df.sort()#排序从小到大排序

1	< span class = "n" > df < / span > < span class = "o" > . < / span > < span class = "n" > sort < / span > < span class = "p" > ( ) < / span > < span class = "c" > #排序从小到大排序</span>

Out[60]:

	A	B	C	D
2016-07-15	0.736079	0.959340	0.830599	0.627481
2016-07-16	0.183782	0.740787	0.589655	0.167018
2016-07-17	0.198436	0.452805	0.275851	0.119994
2016-07-18	0.865754	0.584943	0.381434	0.966995
2016-07-19	0.095199	0.431479	0.394274	0.041155
2016-07-20	0.731607	0.018931	0.694380	0.189079

In [64]:

Python

df.sort('C')#根据C这个列表进行从小到大排序

1	< span class = "n" > df < / span > < span class = "o" > . < / span > < span class = "n" > sort < / span > < span class = "p" > ( < / span > < span class = "s" > 'C' < / span > < span class = "p" > ) < / span > < span class = "c" > #根据C这个列表进行从小到大排序</span>

Out[64]:

	A	B	C	D
2016-07-17	0.198436	0.452805	0.275851	0.119994
2016-07-18	0.865754	0.584943	0.381434	0.966995
2016-07-19	0.095199	0.431479	0.394274	0.041155
2016-07-16	0.183782	0.740787	0.589655	0.167018
2016-07-20	0.731607	0.018931	0.694380	0.189079
2016-07-15	0.736079	0.959340	0.830599	0.627481

In [77]:

Python

df1 = pd.DataFrame(np.random.randn(6,4),columns=list('abcd')) df1

df1 = pd . DataFrame ( np . random . randn ( 6 , 4 ) , columns = list ( 'abcd' ) )

df1

Out[77]:

	a	b	c	d
0	1.225333	-0.694005	-0.868498	2.540235
1	-0.089846	0.075165	0.722056	0.261062
2	1.087733	-0.590180	0.139107	-0.768135
3	1.587061	-0.176495	-0.784779	0.186754
4	0.978927	0.244961	-0.576200	3.148124
5	-0.057562	0.575155	0.550383	-0.859195

In [78]:

Python

df1[df1.d>0]

1	< span class = "n" > df1 < / span > < span class = "p" > [ < / span > < span class = "n" > df1 < / span > < span class = "o" > . < / span > < span class = "n" > d < / span > < span class = "o" >> < / span > < span class = "mi" > 0 < / span > < span class = "p" > ] < / span >

Out[78]:

	a	b	c	d
0	1.225333	-0.694005	-0.868498	2.540235
1	-0.089846	0.075165	0.722056	0.261062
3	1.587061	-0.176495	-0.784779	0.186754
4	0.978927	0.244961	-0.576200	3.148124

In [97]:

Python

df1[df1.c<0][['a','b']]

df1 [ df1 . c < 0 ] [ [ 'a' , 'b' ] ]

Out[97]:

	a	b
0	1.225333	-0.694005
3	1.587061	-0.176495
4	0.978927	0.244961

In [280]:

Python

''' 第二节： #pandas 库之字符串提取与操作 ************************************ '''

'''

第二节：

#pandas 库之字符串提取与操作 ************************************

'''

Out[280]:

Python

'\n\n\xe7\xac\xac\xe4\xba\x8c\xe8\x8a\x82\xef\xbc\x9a\n#pandas \xe5\xba\x93\xe4\xb9\x8b\xe5\xad\x97\xe7\xac\xa6\xe4\xb8\xb2\xe6\x8f\x90\xe5\x8f\x96\xe4\xb8\x8e\xe6\x93\x8d\xe4\xbd\x9c ************************************\n\n'

1	'\n\n\xe7\xac\xac\xe4\xba\x8c\xe8\x8a\x82\xef\xbc\x9a\n#pandas \xe5\xba\x93\xe4\xb9\x8b\xe5\xad\x97\xe7\xac\xa6\xe4\xb8\xb2\xe6\x8f\x90\xe5\x8f\x96\xe4\xb8\x8e\xe6\x93\x8d\xe4\xbd\x9c ************************************\n\n'

In [227]:

Python

s = pd.Series(list('ABCDEF')) s

s = pd . Series ( list ( 'ABCDEF' ) )

s

Out[227]:

Python

0 A 1 B 2 C 3 D 4 E 5 F dtype: object

0 A

1 B

2 C

3 D

4 E

5 F

dtype : object

In [228]:

Python

s.str.lower()#.lower()将字符串转化为小写

1	< span class = "n" > s < / span > < span class = "o" > . < / span > < span class = "n" > str < / span > < span class = "o" > . < / span > < span class = "n" > lower < / span > < span class = "p" > ( ) < / span > < span class = "c" > #.lower()将字符串转化为小写</span>

Out[228]:

Python

0 a 1 b 2 c 3 d 4 e 5 f dtype: object

0 a

1 b

2 c

3 d

4 e

5 f

dtype : object

In [229]:

Python

s.str.upper()#.upper()将字符串转化为大写

1	< span class = "n" > s < / span > < span class = "o" > . < / span > < span class = "n" > str < / span > < span class = "o" > . < / span > < span class = "n" > upper < / span > < span class = "p" > ( ) < / span > < span class = "c" > #.upper()将字符串转化为大写</span>

Out[229]:

Python

0 A 1 B 2 C 3 D 4 E 5 F dtype: object

0 A

1 B

2 C

3 D

4 E

5 F

dtype : object

In [230]:

Python

s.str.len()#.str.len()求字符串长度

1	< span class = "n" > s < / span > < span class = "o" > . < / span > < span class = "n" > str < / span > < span class = "o" > . < / span > < span class = "n" > len < / span > < span class = "p" > ( ) < / span > < span class = "c" > #.str.len()求字符串长度</span>

Out[230]:

Python

0 1 1 1 2 1 3 1 4 1 5 1 dtype: int64

0 1

1 1

2 1

3 1

4 1

5 1

dtype : int64

In [231]:

Python

s.str.split('')#.split('')切割字符串（'这里写分隔符'）

s . str . split ( '' ) #.split('')切割字符串（'这里写分隔符'）

Out[231]:

Python

0 [A] 1 [B] 2 [C] 3 [D] 4 [E] 5 [F] dtype: object

0 [ A ]

1 [ B ]

2 [ C ]

3 [ D ]

4 [ E ]

5 [ F ]

dtype : object

In [232]:

Python

s.str.replace('A','Z')#.replace()将字符串替换成另外的

s . str . replace ( 'A' , 'Z' ) #.replace()将字符串替换成另外的

Out[232]:

Python

0 Z 1 B 2 C 3 D 4 E 5 F dtype: object

0 Z

1 B

2 C

3 D

4 E

5 F

dtype : object

In [233]:

Python

s1 = pd.Series(['a1','a2','a3','a4'])#创建一个新的序列 s1

s1 = pd . Series ( [ 'a1' , 'a2' , 'a3' , 'a4' ] ) #创建一个新的序列

s1

Out[233]:

Python

0 a1 1 a2 2 a3 3 a4 dtype: object

0 a1

1 a2

2 a3

3 a4

dtype : object

In [238]:

Python

s1 . str . extract ( '[ab](\d)' ) #提取

Out[238]:

Python

0 1 1 2 2 3 3 4 dtype: object

0 1

1 2

2 3

3 4

dtype : object

In [239]:

Python

s1.str.extract('([abc])(\d)')#提取

s1 . str . extract ( '([abc])(\d)' ) #提取

Out[239]:

	0	1
0	a	1
1	a	2
2	a	3
3	a	4

In [240]:

Python

s1.str.extract('(?P<str>[abc])(?P<digit>\d)')#提取

s1 . str . extract ( '(?P<str>[abc])(?P<digit>\d)' ) #提取

Out[240]:

	str	digit
0	a	1
1	a	2
2	a	3
3	a	4

In [253]:

Python

s2 = pd.Series(['a','B','c','d']) a_z = r'[a-z]'#正则表达式 s2.str.contains(a_z)#.contains()检测列表里面有没有包含指定的内容

a_z = r '[a-z]' #正则表达式

s2 . str . contains ( a_z ) #.contains()检测列表里面有没有包含指定的内容

Out[253]:

Python

0 True 1 False 2 True 3 True dtype: bool

0 True

1 False

2 True

3 True

dtype : bool

In [267]:

Python

s3 = pd.Series(['ab','Ba','ac','d']) s3

s3 = pd . Series ( [ 'ab' , 'Ba' , 'ac' , 'd' ] )

s3

Out[267]:

Python

0 ab 1 Ba 2 ac 3 d dtype: object

0 ab

1 Ba

2 ac

3 d

dtype : object

In [268]:

Python

s3.str.contains('^a')#.contains('^a')检测列表里面有没有包含指定的a开头的内容并返回bool值

s3 . str . contains ( '^a' ) #.contains('^a')检测列表里面有没有包含指定的a开头的内容并返回bool值

Out[268]:

Python

0 True 1 False 2 True 3 False dtype: bool

0 True

1 False

2 True

3 False

dtype : bool

In [271]:

Python

s3.str.startswith('a')#.startswith('')检测列表里面有没有包含指定的a开头的内容并返回bool值，同上

s3 . str . startswith ( 'a' ) #.startswith('')检测列表里面有没有包含指定的a开头的内容并返回bool值，同上

Out[271]:

Python

0 True 1 False 2 True 3 False dtype: bool

0 True

1 False

2 True

3 False

dtype : bool

In [272]:

Python

s3.str.endswith('a')#.endswith('')检测列表里面有没有包含指定的a结尾的内容并返回bool值

s3 . str . endswith ( 'a' ) #.endswith('')检测列表里面有没有包含指定的a结尾的内容并返回bool值

Out[272]:

Python

0 False 1 True 2 False 3 False dtype: bool

0 False

1 True

2 False

3 False

dtype : bool

In [275]:

Python

s3.str.contains('a$')#.contains('a$')检测列表里面有没有包含指定的a结尾的内容并返回bool值，同上

s3 . str . contains ( 'a$' ) #.contains('a$')检测列表里面有没有包含指定的a结尾的内容并返回bool值，同上

Out[275]:

Python

0 False 1 True 2 False 3 False dtype: bool

0 False

1 True

2 False

3 False

dtype : bool

In [281]:

Python

''' 第三节： #pandas 库之散点图 ************************************ '''

'''

第三节：

#pandas 库之散点图 ************************************

'''

Out[281]:

Python

'\n\n\xe7\xac\xac\xe4\xb8\x89\xe8\x8a\x82\xef\xbc\x9a\n#pandas \xe5\xba\x93\xe4\xb9\x8b\xe6\x95\xa3\xe7\x82\xb9\xe5\x9b\xbe ************************************\n\n'

1	'\n\n\xe7\xac\xac\xe4\xb8\x89\xe8\x8a\x82\xef\xbc\x9a\n#pandas \xe5\xba\x93\xe4\xb9\x8b\xe6\x95\xa3\xe7\x82\xb9\xe5\x9b\xbe ************************************\n\n'

In [14]:

Python

duqu = pd.read_csv('603318.XSHG_1m.csv')#读取.csv文件：pd.read_csv('路径') duqu.head()

duqu = pd . read_csv ( '603318.XSHG_1m.csv' ) #读取.csv文件：pd.read_csv('路径')

duqu . head ( )

Out[14]:

	Unnamed: 0	open	close	high	low	volume	money
0	2015-04-24 09:30:00	9.39	9.39	9.39	9.39	100	939
1	2015-04-24 09:31:00	9.39	9.39	9.39	9.39	2000	18780
2	2015-04-24 09:32:00	9.39	9.39	9.39	9.39	1000	9390
3	2015-04-24 09:33:00	9.39	9.39	9.39	9.39	1000	9390
4	2015-04-24 09:34:00	9.39	9.39	9.39	9.39	0	0

In [306]:

Python

pl = duqu.plot(kind='scatter',x='volume',y='money').get_figure() #.plot(kind='种类函数',x轴,y轴)绘制散点图 pl.savefig('1.jpg')#保存图片

pl = duqu . plot ( kind = 'scatter' , x = 'volume' , y = 'money' ) . get_figure ( )

#.plot(kind='种类函数',x轴,y轴)绘制散点图

pl . savefig ( '1.jpg' ) #保存图片

In [20]:

Python

''' 第四节： #pandas 库之柱形图\直方图\箱型图 ************************************ '''

'''

第四节：

#pandas 库之柱形图\直方图\箱型图 ************************************

'''

Out[20]:

Python

'\n\n\xe7\xac\xac\xe5\x9b\x9b\xe8\x8a\x82\xef\xbc\x9a\n#pandas \xe5\xba\x93\xe4\xb9\x8b\xe6\x9f\xb1\xe5\xbd\xa2\xe5\x9b\xbe\\\xe7\x9b\xb4\xe6\x96\xb9\xe5\x9b\xbe\\\xe7\xae\xb1\xe5\x9e\x8b\xe5\x9b\xbe ************************************\n\n'

1	'\n\n\xe7\xac\xac\xe5\x9b\x9b\xe8\x8a\x82\xef\xbc\x9a\n#pandas \xe5\xba\x93\xe4\xb9\x8b\xe6\x9f\xb1\xe5\xbd\xa2\xe5\x9b\xbe\\\xe7\x9b\xb4\xe6\x96\xb9\xe5\x9b\xbe\\\xe7\xae\xb1\xe5\x9e\x8b\xe5\x9b\xbe ************************************\n\n'

In [9]:

Python

df6 = pd.DataFrame(np.random.rand(10,4),columns=list('ABCD')) pd.set_option('mpl_style','default')#设置风格kind='bar' 为柱形图 plt6 = df6.plot(kind='bar',stacked=True).get_figure()#.plot(kind='风格',stacked=是否堆积效果bool) plt6.savefig('2.jpg')

plt6 = df6 . plot ( kind = 'bar' , stacked = True ) . get_figure ( ) #.plot(kind='风格',stacked=是否堆积效果bool)

plt6 . savefig ( '2.jpg' )

In [19]:

Python

df7 = pd.DataFrame(np.random.rand(100,4),columns=list('abcd')) d8 = df7['a'].hist().get_figure()#绘制直方图 d8.savefig('3.jpg')

df7 = pd . DataFrame ( np . random . rand ( 100 , 4 ) , columns = list ( 'abcd' ) )

d8 = df7 [ 'a' ] . hist ( ) . get_figure ( ) #绘制直方图

d8 . savefig ( '3.jpg' )

In [33]:

Python

pd.set_option('mpl_style','default') fig,ax = plt.subplots() df9 = pd.DataFrame(np.random.rand(100,2),columns=list('ab')) df9.boxplot(ax=ax)#绘制箱型图 plt.show()

fig , ax = plt . subplots ( )

df9 = pd . DataFrame ( np . random . rand ( 100 , 2 ) , columns = list ( 'ab' ) )

df9 . boxplot ( ax = ax ) #绘制箱型图

plt . show ( )