prettytable 是一款很简洁但是功能强大的第三方模块,主要是将输入的数据转化为格式化的形式来输出,即:以表格的形式的打印输出出来,能够起到美观的效果,今天简单地试用了一下,
一、下载与安装
进入pypi.python.org查找并下载prettytable将其放在python文件夹下的scripts文件夹下
进入命令提示符工具,转到scripts文件夹下,通过命令pip install prettytable-0.7.2.tar.bz2安装该模块
二、简单的使用
导入该模块
1
|
from prettytable import prettytable |
创建表头
1
|
table = prettytable([ "姓名" , "学号" , "性别" ]) |
插入数据
1
2
3
|
table.add_row([ "小明" , "01" , "男" ]) table.add_row([ "小红" , "02" , "女" ]) table.add_row([ "小黄" , "03" , "男" ]) |
显示该表
1
|
print (table) |
三、下面是具体的实践:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
#!usr/bin/env python #encoding:utf-8 ''' __author__:沂水寒城 功能: prettytable 模块使用 ''' import prettytable from prettytable import from_csv from prettytable import prettytable def testfunc1(): ''' ''' table = prettytable() table.field_names = [ "city name" , "area" , "population" , "annual rainfall" ] table.add_row([ "adelaide" , 1295 , 1158259 , 600.5 ]) table.add_row([ "brisbane" , 5905 , 1857594 , 1146.4 ]) table.add_row([ "darwin" , 112 , 120900 , 1714.7 ]) table.add_row([ "hobart" , 1357 , 205556 , 619.5 ]) table.add_row([ "sydney" , 2058 , 4336374 , 1214.8 ]) table.add_row([ "melbourne" , 1566 , 3806092 , 646.9 ]) table.add_row([ "perth" , 5386 , 1554769 , 869.4 ]) print '=================================table====================================' print table table.add_column( "city name" ,[ "adelaide" , "brisbane" , "darwin" , "hobart" , "sydney" , "melbourne" , "perth" ]) table.add_column( "area" ,[ 1295 , 5905 , 112 , 1357 , 2058 , 1566 , 5386 ]) table.add_column( "population" ,[ 1158259 , 1857594 , 120900 , 205556 , 4336374 , 3806092 , 1554769 ]) table.add_column( "annual rainfall" ,[ 600.5 , 1146.4 , 1714.7 , 619.5 , 1214.8 , 646.9 , 869.4 ]) print '=================================table====================================' print table def testfunc2(data = 'mycsv.csv' ): ''' 从 csv 文件中加载数据 ''' mycsv = open (data) table = from_csv(mycsv) mycsv.close() print '===========================================table==============================================' print table print '=================================table:sepallength_species====================================' print table.get_string(fields = [ 'sepallength' , 'species' ]) print '=======================================table:60=>80 rows======================================' print table.get_string(start = 60 ,end = 80 ) if __name__ = = '__main__' : testfunc1() testfunc2(data = 'iris.csv' ) |
结果如下:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
|
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = table = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = + - - - - - - - - - - - + - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - + | city name | area | population | annual rainfall | + - - - - - - - - - - - + - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - + | adelaide | 1295 | 1158259 | 600.5 | | brisbane | 5905 | 1857594 | 1146.4 | | darwin | 112 | 120900 | 1714.7 | | hobart | 1357 | 205556 | 619.5 | | sydney | 2058 | 4336374 | 1214.8 | | melbourne | 1566 | 3806092 | 646.9 | | perth | 5386 | 1554769 | 869.4 | + - - - - - - - - - - - + - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - + = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = table = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = + - - - - - - - - - - - + - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - + - - - - - - - - - - - + - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - + | city name | area | population | annual rainfall | city name | area | population | annual rainfall | + - - - - - - - - - - - + - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - + - - - - - - - - - - - + - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - + | adelaide | 1295 | 1158259 | 600.5 | adelaide | 1295 | 1158259 | 600.5 | | brisbane | 5905 | 1857594 | 1146.4 | brisbane | 5905 | 1857594 | 1146.4 | | darwin | 112 | 120900 | 1714.7 | darwin | 112 | 120900 | 1714.7 | | hobart | 1357 | 205556 | 619.5 | hobart | 1357 | 205556 | 619.5 | | sydney | 2058 | 4336374 | 1214.8 | sydney | 2058 | 4336374 | 1214.8 | | melbourne | 1566 | 3806092 | 646.9 | melbourne | 1566 | 3806092 | 646.9 | | perth | 5386 | 1554769 | 869.4 | perth | 5386 | 1554769 | 869.4 | + - - - - - - - - - - - + - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - + - - - - - - - - - - - + - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - - - - - + = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = table = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = + - - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - + | id | sepallength | sepalwidth | petallength | petalwidth | species | + - - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - + | 1 | 5.1 | 3.5 | 1.4 | 0.2 | setosa | | 2 | 4.9 | 3 | 1.4 | 0.2 | setosa | | 3 | 4.7 | 3.2 | 1.3 | 0.2 | setosa | | 4 | 4.6 | 3.1 | 1.5 | 0.2 | setosa | | 5 | 5 | 3.6 | 1.4 | 0.2 | setosa | | 6 | 5.4 | 3.9 | 1.7 | 0.4 | setosa | | 7 | 4.6 | 3.4 | 1.4 | 0.3 | setosa | | 8 | 5 | 3.4 | 1.5 | 0.2 | setosa | | 9 | 4.4 | 2.9 | 1.4 | 0.2 | setosa | | 10 | 4.9 | 3.1 | 1.5 | 0.1 | setosa | | 11 | 5.4 | 3.7 | 1.5 | 0.2 | setosa | | 12 | 4.8 | 3.4 | 1.6 | 0.2 | setosa | | 13 | 4.8 | 3 | 1.4 | 0.1 | setosa | | 14 | 4.3 | 3 | 1.1 | 0.1 | setosa | | 15 | 5.8 | 4 | 1.2 | 0.2 | setosa | | 16 | 5.7 | 4.4 | 1.5 | 0.4 | setosa | | 17 | 5.4 | 3.9 | 1.3 | 0.4 | setosa | | 18 | 5.1 | 3.5 | 1.4 | 0.3 | setosa | | 19 | 5.7 | 3.8 | 1.7 | 0.3 | setosa | | 20 | 5.1 | 3.8 | 1.5 | 0.3 | setosa | | 21 | 5.4 | 3.4 | 1.7 | 0.2 | setosa | | 22 | 5.1 | 3.7 | 1.5 | 0.4 | setosa | | 23 | 4.6 | 3.6 | 1 | 0.2 | setosa | | 24 | 5.1 | 3.3 | 1.7 | 0.5 | setosa | | 25 | 4.8 | 3.4 | 1.9 | 0.2 | setosa | | 26 | 5 | 3 | 1.6 | 0.2 | setosa | | 27 | 5 | 3.4 | 1.6 | 0.4 | setosa | | 28 | 5.2 | 3.5 | 1.5 | 0.2 | setosa | | 29 | 5.2 | 3.4 | 1.4 | 0.2 | setosa | | 30 | 4.7 | 3.2 | 1.6 | 0.2 | setosa | | 31 | 4.8 | 3.1 | 1.6 | 0.2 | setosa | | 32 | 5.4 | 3.4 | 1.5 | 0.4 | setosa | | 33 | 5.2 | 4.1 | 1.5 | 0.1 | setosa | | 34 | 5.5 | 4.2 | 1.4 | 0.2 | setosa | | 35 | 4.9 | 3.1 | 1.5 | 0.2 | setosa | | 36 | 5 | 3.2 | 1.2 | 0.2 | setosa | | 37 | 5.5 | 3.5 | 1.3 | 0.2 | setosa | | 38 | 4.9 | 3.6 | 1.4 | 0.1 | setosa | | 39 | 4.4 | 3 | 1.3 | 0.2 | setosa | | 40 | 5.1 | 3.4 | 1.5 | 0.2 | setosa | | 41 | 5 | 3.5 | 1.3 | 0.3 | setosa | | 42 | 4.5 | 2.3 | 1.3 | 0.3 | setosa | | 43 | 4.4 | 3.2 | 1.3 | 0.2 | setosa | | 44 | 5 | 3.5 | 1.6 | 0.6 | setosa | | 45 | 5.1 | 3.8 | 1.9 | 0.4 | setosa | | 46 | 4.8 | 3 | 1.4 | 0.3 | setosa | | 47 | 5.1 | 3.8 | 1.6 | 0.2 | setosa | | 48 | 4.6 | 3.2 | 1.4 | 0.2 | setosa | | 49 | 5.3 | 3.7 | 1.5 | 0.2 | setosa | | 50 | 5 | 3.3 | 1.4 | 0.2 | setosa | | 51 | 7 | 3.2 | 4.7 | 1.4 | versicolor | | 52 | 6.4 | 3.2 | 4.5 | 1.5 | versicolor | | 53 | 6.9 | 3.1 | 4.9 | 1.5 | versicolor | | 54 | 5.5 | 2.3 | 4 | 1.3 | versicolor | | 55 | 6.5 | 2.8 | 4.6 | 1.5 | versicolor | | 56 | 5.7 | 2.8 | 4.5 | 1.3 | versicolor | | 57 | 6.3 | 3.3 | 4.7 | 1.6 | versicolor | | 58 | 4.9 | 2.4 | 3.3 | 1 | versicolor | | 59 | 6.6 | 2.9 | 4.6 | 1.3 | versicolor | | 60 | 5.2 | 2.7 | 3.9 | 1.4 | versicolor | | 61 | 5 | 2 | 3.5 | 1 | versicolor | | 62 | 5.9 | 3 | 4.2 | 1.5 | versicolor | | 63 | 6 | 2.2 | 4 | 1 | versicolor | | 64 | 6.1 | 2.9 | 4.7 | 1.4 | versicolor | | 65 | 5.6 | 2.9 | 3.6 | 1.3 | versicolor | | 66 | 6.7 | 3.1 | 4.4 | 1.4 | versicolor | | 67 | 5.6 | 3 | 4.5 | 1.5 | versicolor | | 68 | 5.8 | 2.7 | 4.1 | 1 | versicolor | | 69 | 6.2 | 2.2 | 4.5 | 1.5 | versicolor | | 70 | 5.6 | 2.5 | 3.9 | 1.1 | versicolor | | 71 | 5.9 | 3.2 | 4.8 | 1.8 | versicolor | | 72 | 6.1 | 2.8 | 4 | 1.3 | versicolor | | 73 | 6.3 | 2.5 | 4.9 | 1.5 | versicolor | | 74 | 6.1 | 2.8 | 4.7 | 1.2 | versicolor | | 75 | 6.4 | 2.9 | 4.3 | 1.3 | versicolor | | 76 | 6.6 | 3 | 4.4 | 1.4 | versicolor | | 77 | 6.8 | 2.8 | 4.8 | 1.4 | versicolor | | 78 | 6.7 | 3 | 5 | 1.7 | versicolor | | 79 | 6 | 2.9 | 4.5 | 1.5 | versicolor | | 80 | 5.7 | 2.6 | 3.5 | 1 | versicolor | | 81 | 5.5 | 2.4 | 3.8 | 1.1 | versicolor | | 82 | 5.5 | 2.4 | 3.7 | 1 | versicolor | | 83 | 5.8 | 2.7 | 3.9 | 1.2 | versicolor | | 84 | 6 | 2.7 | 5.1 | 1.6 | versicolor | | 85 | 5.4 | 3 | 4.5 | 1.5 | versicolor | | 86 | 6 | 3.4 | 4.5 | 1.6 | versicolor | | 87 | 6.7 | 3.1 | 4.7 | 1.5 | versicolor | | 88 | 6.3 | 2.3 | 4.4 | 1.3 | versicolor | | 89 | 5.6 | 3 | 4.1 | 1.3 | versicolor | | 90 | 5.5 | 2.5 | 4 | 1.3 | versicolor | | 91 | 5.5 | 2.6 | 4.4 | 1.2 | versicolor | | 92 | 6.1 | 3 | 4.6 | 1.4 | versicolor | | 93 | 5.8 | 2.6 | 4 | 1.2 | versicolor | | 94 | 5 | 2.3 | 3.3 | 1 | versicolor | | 95 | 5.6 | 2.7 | 4.2 | 1.3 | versicolor | | 96 | 5.7 | 3 | 4.2 | 1.2 | versicolor | | 97 | 5.7 | 2.9 | 4.2 | 1.3 | versicolor | | 98 | 6.2 | 2.9 | 4.3 | 1.3 | versicolor | | 99 | 5.1 | 2.5 | 3 | 1.1 | versicolor | | 100 | 5.7 | 2.8 | 4.1 | 1.3 | versicolor | | 101 | 6.3 | 3.3 | 6 | 2.5 | virginica | | 102 | 5.8 | 2.7 | 5.1 | 1.9 | virginica | | 103 | 7.1 | 3 | 5.9 | 2.1 | virginica | | 104 | 6.3 | 2.9 | 5.6 | 1.8 | virginica | | 105 | 6.5 | 3 | 5.8 | 2.2 | virginica | | 106 | 7.6 | 3 | 6.6 | 2.1 | virginica | | 107 | 4.9 | 2.5 | 4.5 | 1.7 | virginica | | 108 | 7.3 | 2.9 | 6.3 | 1.8 | virginica | | 109 | 6.7 | 2.5 | 5.8 | 1.8 | virginica | | 110 | 7.2 | 3.6 | 6.1 | 2.5 | virginica | | 111 | 6.5 | 3.2 | 5.1 | 2 | virginica | | 112 | 6.4 | 2.7 | 5.3 | 1.9 | virginica | | 113 | 6.8 | 3 | 5.5 | 2.1 | virginica | | 114 | 5.7 | 2.5 | 5 | 2 | virginica | | 115 | 5.8 | 2.8 | 5.1 | 2.4 | virginica | | 116 | 6.4 | 3.2 | 5.3 | 2.3 | virginica | | 117 | 6.5 | 3 | 5.5 | 1.8 | virginica | | 118 | 7.7 | 3.8 | 6.7 | 2.2 | virginica | | 119 | 7.7 | 2.6 | 6.9 | 2.3 | virginica | | 120 | 6 | 2.2 | 5 | 1.5 | virginica | | 121 | 6.9 | 3.2 | 5.7 | 2.3 | virginica | | 122 | 5.6 | 2.8 | 4.9 | 2 | virginica | | 123 | 7.7 | 2.8 | 6.7 | 2 | virginica | | 124 | 6.3 | 2.7 | 4.9 | 1.8 | virginica | | 125 | 6.7 | 3.3 | 5.7 | 2.1 | virginica | | 126 | 7.2 | 3.2 | 6 | 1.8 | virginica | | 127 | 6.2 | 2.8 | 4.8 | 1.8 | virginica | | 128 | 6.1 | 3 | 4.9 | 1.8 | virginica | | 129 | 6.4 | 2.8 | 5.6 | 2.1 | virginica | | 130 | 7.2 | 3 | 5.8 | 1.6 | virginica | | 131 | 7.4 | 2.8 | 6.1 | 1.9 | virginica | | 132 | 7.9 | 3.8 | 6.4 | 2 | virginica | | 133 | 6.4 | 2.8 | 5.6 | 2.2 | virginica | | 134 | 6.3 | 2.8 | 5.1 | 1.5 | virginica | | 135 | 6.1 | 2.6 | 5.6 | 1.4 | virginica | | 136 | 7.7 | 3 | 6.1 | 2.3 | virginica | | 137 | 6.3 | 3.4 | 5.6 | 2.4 | virginica | | 138 | 6.4 | 3.1 | 5.5 | 1.8 | virginica | | 139 | 6 | 3 | 4.8 | 1.8 | virginica | | 140 | 6.9 | 3.1 | 5.4 | 2.1 | virginica | | 141 | 6.7 | 3.1 | 5.6 | 2.4 | virginica | | 142 | 6.9 | 3.1 | 5.1 | 2.3 | virginica | | 143 | 5.8 | 2.7 | 5.1 | 1.9 | virginica | | 144 | 6.8 | 3.2 | 5.9 | 2.3 | virginica | | 145 | 6.7 | 3.3 | 5.7 | 2.5 | virginica | | 146 | 6.7 | 3 | 5.2 | 2.3 | virginica | | 147 | 6.3 | 2.5 | 5 | 1.9 | virginica | | 148 | 6.5 | 3 | 5.2 | 2 | virginica | | 149 | 6.2 | 3.4 | 5.4 | 2.3 | virginica | | 150 | 5.9 | 3 | 5.1 | 1.8 | virginica | + - - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - + = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = table:sepallength_species = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = + - - - - - - - - - - - - - + - - - - - - - - - - - - + | sepallength | species | + - - - - - - - - - - - - - + - - - - - - - - - - - - + | 5.1 | setosa | | 4.9 | setosa | | 4.7 | setosa | | 4.6 | setosa | | 5 | setosa | | 5.4 | setosa | | 4.6 | setosa | | 5 | setosa | | 4.4 | setosa | | 4.9 | setosa | | 5.4 | setosa | | 4.8 | setosa | | 4.8 | setosa | | 4.3 | setosa | | 5.8 | setosa | | 5.7 | setosa | | 5.4 | setosa | | 5.1 | setosa | | 5.7 | setosa | | 5.1 | setosa | | 5.4 | setosa | | 5.1 | setosa | | 4.6 | setosa | | 5.1 | setosa | | 4.8 | setosa | | 5 | setosa | | 5 | setosa | | 5.2 | setosa | | 5.2 | setosa | | 4.7 | setosa | | 4.8 | setosa | | 5.4 | setosa | | 5.2 | setosa | | 5.5 | setosa | | 4.9 | setosa | | 5 | setosa | | 5.5 | setosa | | 4.9 | setosa | | 4.4 | setosa | | 5.1 | setosa | | 5 | setosa | | 4.5 | setosa | | 4.4 | setosa | | 5 | setosa | | 5.1 | setosa | | 4.8 | setosa | | 5.1 | setosa | | 4.6 | setosa | | 5.3 | setosa | | 5 | setosa | | 7 | versicolor | | 6.4 | versicolor | | 6.9 | versicolor | | 5.5 | versicolor | | 6.5 | versicolor | | 5.7 | versicolor | | 6.3 | versicolor | | 4.9 | versicolor | | 6.6 | versicolor | | 5.2 | versicolor | | 5 | versicolor | | 5.9 | versicolor | | 6 | versicolor | | 6.1 | versicolor | | 5.6 | versicolor | | 6.7 | versicolor | | 5.6 | versicolor | | 5.8 | versicolor | | 6.2 | versicolor | | 5.6 | versicolor | | 5.9 | versicolor | | 6.1 | versicolor | | 6.3 | versicolor | | 6.1 | versicolor | | 6.4 | versicolor | | 6.6 | versicolor | | 6.8 | versicolor | | 6.7 | versicolor | | 6 | versicolor | | 5.7 | versicolor | | 5.5 | versicolor | | 5.5 | versicolor | | 5.8 | versicolor | | 6 | versicolor | | 5.4 | versicolor | | 6 | versicolor | | 6.7 | versicolor | | 6.3 | versicolor | | 5.6 | versicolor | | 5.5 | versicolor | | 5.5 | versicolor | | 6.1 | versicolor | | 5.8 | versicolor | | 5 | versicolor | | 5.6 | versicolor | | 5.7 | versicolor | | 5.7 | versicolor | | 6.2 | versicolor | | 5.1 | versicolor | | 5.7 | versicolor | | 6.3 | virginica | | 5.8 | virginica | | 7.1 | virginica | | 6.3 | virginica | | 6.5 | virginica | | 7.6 | virginica | | 4.9 | virginica | | 7.3 | virginica | | 6.7 | virginica | | 7.2 | virginica | | 6.5 | virginica | | 6.4 | virginica | | 6.8 | virginica | | 5.7 | virginica | | 5.8 | virginica | | 6.4 | virginica | | 6.5 | virginica | | 7.7 | virginica | | 7.7 | virginica | | 6 | virginica | | 6.9 | virginica | | 5.6 | virginica | | 7.7 | virginica | | 6.3 | virginica | | 6.7 | virginica | | 7.2 | virginica | | 6.2 | virginica | | 6.1 | virginica | | 6.4 | virginica | | 7.2 | virginica | | 7.4 | virginica | | 7.9 | virginica | | 6.4 | virginica | | 6.3 | virginica | | 6.1 | virginica | | 7.7 | virginica | | 6.3 | virginica | | 6.4 | virginica | | 6 | virginica | | 6.9 | virginica | | 6.7 | virginica | | 6.9 | virginica | | 5.8 | virginica | | 6.8 | virginica | | 6.7 | virginica | | 6.7 | virginica | | 6.3 | virginica | | 6.5 | virginica | | 6.2 | virginica | | 5.9 | virginica | + - - - - - - - - - - - - - + - - - - - - - - - - - - + = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = table: 60 = > 80 rows = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = + - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - + | id | sepallength | sepalwidth | petallength | petalwidth | species | + - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - + | 61 | 5 | 2 | 3.5 | 1 | versicolor | | 62 | 5.9 | 3 | 4.2 | 1.5 | versicolor | | 63 | 6 | 2.2 | 4 | 1 | versicolor | | 64 | 6.1 | 2.9 | 4.7 | 1.4 | versicolor | | 65 | 5.6 | 2.9 | 3.6 | 1.3 | versicolor | | 66 | 6.7 | 3.1 | 4.4 | 1.4 | versicolor | | 67 | 5.6 | 3 | 4.5 | 1.5 | versicolor | | 68 | 5.8 | 2.7 | 4.1 | 1 | versicolor | | 69 | 6.2 | 2.2 | 4.5 | 1.5 | versicolor | | 70 | 5.6 | 2.5 | 3.9 | 1.1 | versicolor | | 71 | 5.9 | 3.2 | 4.8 | 1.8 | versicolor | | 72 | 6.1 | 2.8 | 4 | 1.3 | versicolor | | 73 | 6.3 | 2.5 | 4.9 | 1.5 | versicolor | | 74 | 6.1 | 2.8 | 4.7 | 1.2 | versicolor | | 75 | 6.4 | 2.9 | 4.3 | 1.3 | versicolor | | 76 | 6.6 | 3 | 4.4 | 1.4 | versicolor | | 77 | 6.8 | 2.8 | 4.8 | 1.4 | versicolor | | 78 | 6.7 | 3 | 5 | 1.7 | versicolor | | 79 | 6 | 2.9 | 4.5 | 1.5 | versicolor | | 80 | 5.7 | 2.6 | 3.5 | 1 | versicolor | + - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - - + - - - - - - - - - - - - + - - - - - - - - - - - - + |
这样的结果输出果然是比原始数据好看了许多,这里顺便贴出来代码中使用到的iris.csv数据集,内容如下:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
|
id ,sepallength,sepalwidth,petallength,petalwidth,species 1 , 5.1 , 3.5 , 1.4 , 0.2 ,setosa 2 , 4.9 , 3 , 1.4 , 0.2 ,setosa 3 , 4.7 , 3.2 , 1.3 , 0.2 ,setosa 4 , 4.6 , 3.1 , 1.5 , 0.2 ,setosa 5 , 5 , 3.6 , 1.4 , 0.2 ,setosa 6 , 5.4 , 3.9 , 1.7 , 0.4 ,setosa 7 , 4.6 , 3.4 , 1.4 , 0.3 ,setosa 8 , 5 , 3.4 , 1.5 , 0.2 ,setosa 9 , 4.4 , 2.9 , 1.4 , 0.2 ,setosa 10 , 4.9 , 3.1 , 1.5 , 0.1 ,setosa 11 , 5.4 , 3.7 , 1.5 , 0.2 ,setosa 12 , 4.8 , 3.4 , 1.6 , 0.2 ,setosa 13 , 4.8 , 3 , 1.4 , 0.1 ,setosa 14 , 4.3 , 3 , 1.1 , 0.1 ,setosa 15 , 5.8 , 4 , 1.2 , 0.2 ,setosa 16 , 5.7 , 4.4 , 1.5 , 0.4 ,setosa 17 , 5.4 , 3.9 , 1.3 , 0.4 ,setosa 18 , 5.1 , 3.5 , 1.4 , 0.3 ,setosa 19 , 5.7 , 3.8 , 1.7 , 0.3 ,setosa 20 , 5.1 , 3.8 , 1.5 , 0.3 ,setosa 21 , 5.4 , 3.4 , 1.7 , 0.2 ,setosa 22 , 5.1 , 3.7 , 1.5 , 0.4 ,setosa 23 , 4.6 , 3.6 , 1 , 0.2 ,setosa 24 , 5.1 , 3.3 , 1.7 , 0.5 ,setosa 25 , 4.8 , 3.4 , 1.9 , 0.2 ,setosa 26 , 5 , 3 , 1.6 , 0.2 ,setosa 27 , 5 , 3.4 , 1.6 , 0.4 ,setosa 28 , 5.2 , 3.5 , 1.5 , 0.2 ,setosa 29 , 5.2 , 3.4 , 1.4 , 0.2 ,setosa 30 , 4.7 , 3.2 , 1.6 , 0.2 ,setosa 31 , 4.8 , 3.1 , 1.6 , 0.2 ,setosa 32 , 5.4 , 3.4 , 1.5 , 0.4 ,setosa 33 , 5.2 , 4.1 , 1.5 , 0.1 ,setosa 34 , 5.5 , 4.2 , 1.4 , 0.2 ,setosa 35 , 4.9 , 3.1 , 1.5 , 0.2 ,setosa 36 , 5 , 3.2 , 1.2 , 0.2 ,setosa 37 , 5.5 , 3.5 , 1.3 , 0.2 ,setosa 38 , 4.9 , 3.6 , 1.4 , 0.1 ,setosa 39 , 4.4 , 3 , 1.3 , 0.2 ,setosa 40 , 5.1 , 3.4 , 1.5 , 0.2 ,setosa 41 , 5 , 3.5 , 1.3 , 0.3 ,setosa 42 , 4.5 , 2.3 , 1.3 , 0.3 ,setosa 43 , 4.4 , 3.2 , 1.3 , 0.2 ,setosa 44 , 5 , 3.5 , 1.6 , 0.6 ,setosa 45 , 5.1 , 3.8 , 1.9 , 0.4 ,setosa 46 , 4.8 , 3 , 1.4 , 0.3 ,setosa 47 , 5.1 , 3.8 , 1.6 , 0.2 ,setosa 48 , 4.6 , 3.2 , 1.4 , 0.2 ,setosa 49 , 5.3 , 3.7 , 1.5 , 0.2 ,setosa 50 , 5 , 3.3 , 1.4 , 0.2 ,setosa 51 , 7 , 3.2 , 4.7 , 1.4 ,versicolor 52 , 6.4 , 3.2 , 4.5 , 1.5 ,versicolor 53 , 6.9 , 3.1 , 4.9 , 1.5 ,versicolor 54 , 5.5 , 2.3 , 4 , 1.3 ,versicolor 55 , 6.5 , 2.8 , 4.6 , 1.5 ,versicolor 56 , 5.7 , 2.8 , 4.5 , 1.3 ,versicolor 57 , 6.3 , 3.3 , 4.7 , 1.6 ,versicolor 58 , 4.9 , 2.4 , 3.3 , 1 ,versicolor 59 , 6.6 , 2.9 , 4.6 , 1.3 ,versicolor 60 , 5.2 , 2.7 , 3.9 , 1.4 ,versicolor 61 , 5 , 2 , 3.5 , 1 ,versicolor 62 , 5.9 , 3 , 4.2 , 1.5 ,versicolor 63 , 6 , 2.2 , 4 , 1 ,versicolor 64 , 6.1 , 2.9 , 4.7 , 1.4 ,versicolor 65 , 5.6 , 2.9 , 3.6 , 1.3 ,versicolor 66 , 6.7 , 3.1 , 4.4 , 1.4 ,versicolor 67 , 5.6 , 3 , 4.5 , 1.5 ,versicolor 68 , 5.8 , 2.7 , 4.1 , 1 ,versicolor 69 , 6.2 , 2.2 , 4.5 , 1.5 ,versicolor 70 , 5.6 , 2.5 , 3.9 , 1.1 ,versicolor 71 , 5.9 , 3.2 , 4.8 , 1.8 ,versicolor 72 , 6.1 , 2.8 , 4 , 1.3 ,versicolor 73 , 6.3 , 2.5 , 4.9 , 1.5 ,versicolor 74 , 6.1 , 2.8 , 4.7 , 1.2 ,versicolor 75 , 6.4 , 2.9 , 4.3 , 1.3 ,versicolor 76 , 6.6 , 3 , 4.4 , 1.4 ,versicolor 77 , 6.8 , 2.8 , 4.8 , 1.4 ,versicolor 78 , 6.7 , 3 , 5 , 1.7 ,versicolor 79 , 6 , 2.9 , 4.5 , 1.5 ,versicolor 80 , 5.7 , 2.6 , 3.5 , 1 ,versicolor 81 , 5.5 , 2.4 , 3.8 , 1.1 ,versicolor 82 , 5.5 , 2.4 , 3.7 , 1 ,versicolor 83 , 5.8 , 2.7 , 3.9 , 1.2 ,versicolor 84 , 6 , 2.7 , 5.1 , 1.6 ,versicolor 85 , 5.4 , 3 , 4.5 , 1.5 ,versicolor 86 , 6 , 3.4 , 4.5 , 1.6 ,versicolor 87 , 6.7 , 3.1 , 4.7 , 1.5 ,versicolor 88 , 6.3 , 2.3 , 4.4 , 1.3 ,versicolor 89 , 5.6 , 3 , 4.1 , 1.3 ,versicolor 90 , 5.5 , 2.5 , 4 , 1.3 ,versicolor 91 , 5.5 , 2.6 , 4.4 , 1.2 ,versicolor 92 , 6.1 , 3 , 4.6 , 1.4 ,versicolor 93 , 5.8 , 2.6 , 4 , 1.2 ,versicolor 94 , 5 , 2.3 , 3.3 , 1 ,versicolor 95 , 5.6 , 2.7 , 4.2 , 1.3 ,versicolor 96 , 5.7 , 3 , 4.2 , 1.2 ,versicolor 97 , 5.7 , 2.9 , 4.2 , 1.3 ,versicolor 98 , 6.2 , 2.9 , 4.3 , 1.3 ,versicolor 99 , 5.1 , 2.5 , 3 , 1.1 ,versicolor 100 , 5.7 , 2.8 , 4.1 , 1.3 ,versicolor 101 , 6.3 , 3.3 , 6 , 2.5 ,virginica 102 , 5.8 , 2.7 , 5.1 , 1.9 ,virginica 103 , 7.1 , 3 , 5.9 , 2.1 ,virginica 104 , 6.3 , 2.9 , 5.6 , 1.8 ,virginica 105 , 6.5 , 3 , 5.8 , 2.2 ,virginica 106 , 7.6 , 3 , 6.6 , 2.1 ,virginica 107 , 4.9 , 2.5 , 4.5 , 1.7 ,virginica 108 , 7.3 , 2.9 , 6.3 , 1.8 ,virginica 109 , 6.7 , 2.5 , 5.8 , 1.8 ,virginica 110 , 7.2 , 3.6 , 6.1 , 2.5 ,virginica 111 , 6.5 , 3.2 , 5.1 , 2 ,virginica 112 , 6.4 , 2.7 , 5.3 , 1.9 ,virginica 113 , 6.8 , 3 , 5.5 , 2.1 ,virginica 114 , 5.7 , 2.5 , 5 , 2 ,virginica 115 , 5.8 , 2.8 , 5.1 , 2.4 ,virginica 116 , 6.4 , 3.2 , 5.3 , 2.3 ,virginica 117 , 6.5 , 3 , 5.5 , 1.8 ,virginica 118 , 7.7 , 3.8 , 6.7 , 2.2 ,virginica 119 , 7.7 , 2.6 , 6.9 , 2.3 ,virginica 120 , 6 , 2.2 , 5 , 1.5 ,virginica 121 , 6.9 , 3.2 , 5.7 , 2.3 ,virginica 122 , 5.6 , 2.8 , 4.9 , 2 ,virginica 123 , 7.7 , 2.8 , 6.7 , 2 ,virginica 124 , 6.3 , 2.7 , 4.9 , 1.8 ,virginica 125 , 6.7 , 3.3 , 5.7 , 2.1 ,virginica 126 , 7.2 , 3.2 , 6 , 1.8 ,virginica 127 , 6.2 , 2.8 , 4.8 , 1.8 ,virginica 128 , 6.1 , 3 , 4.9 , 1.8 ,virginica 129 , 6.4 , 2.8 , 5.6 , 2.1 ,virginica 130 , 7.2 , 3 , 5.8 , 1.6 ,virginica 131 , 7.4 , 2.8 , 6.1 , 1.9 ,virginica 132 , 7.9 , 3.8 , 6.4 , 2 ,virginica 133 , 6.4 , 2.8 , 5.6 , 2.2 ,virginica 134 , 6.3 , 2.8 , 5.1 , 1.5 ,virginica 135 , 6.1 , 2.6 , 5.6 , 1.4 ,virginica 136 , 7.7 , 3 , 6.1 , 2.3 ,virginica 137 , 6.3 , 3.4 , 5.6 , 2.4 ,virginica 138 , 6.4 , 3.1 , 5.5 , 1.8 ,virginica 139 , 6 , 3 , 4.8 , 1.8 ,virginica 140 , 6.9 , 3.1 , 5.4 , 2.1 ,virginica 141 , 6.7 , 3.1 , 5.6 , 2.4 ,virginica 142 , 6.9 , 3.1 , 5.1 , 2.3 ,virginica 143 , 5.8 , 2.7 , 5.1 , 1.9 ,virginica 144 , 6.8 , 3.2 , 5.9 , 2.3 ,virginica 145 , 6.7 , 3.3 , 5.7 , 2.5 ,virginica 146 , 6.7 , 3 , 5.2 , 2.3 ,virginica 147 , 6.3 , 2.5 , 5 , 1.9 ,virginica 148 , 6.5 , 3 , 5.2 , 2 ,virginica 149 , 6.2 , 3.4 , 5.4 , 2.3 ,virginica 150 , 5.9 , 3 , 5.1 , 1.8 ,virginica |
prettytable还可以直接从数据库中读取数据显示出来,这里并没有实践这个,上面的代码testfunc2中实现了读取部分列和指定区间行的作用,感兴趣都可以试试。
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持服务器之家。
原文链接:https://blog.csdn.net/xiaowangku/article/details/79938689