python PrettyTable模块的安装与简单应用

最新推荐文章于 2024-03-05 14:06:38 发布

wx1871428

最新推荐文章于 2024-03-05 14:06:38 发布

阅读量2.8k

点赞数

分类专栏： Python

本文链接：https://blog.csdn.net/wx1871428/article/details/117961279

版权

本文介绍了Python的第三方模块PrettyTable的安装与基本使用。通过它，可以将数据以美观的表格形式输出。文章展示了创建表头、插入数据及显示表格的过程，并提到了可以从数据库读取数据的功能。

摘要由CSDN通过智能技术生成

prettyTable
是一款很简洁但是功能强大的第三方模块，主要是将输入的数据转化为格式化的形式来输出，即：以表格的形式的打印输出出来，能够起到美观的效果，今天简单地试用了一下，

一、下载与安装

进入pypi.python.org查找并下载PrettyTable将其放在Python文件夹下的Scripts文件夹下

进入命令提示符工具，转到Scripts文件夹下，通过命令pip install prettytable-0.7.2.tar.bz2安装该模块

二、简单的使用

导入该模块


    from prettytable import PrettyTable

创建表头


    table=PrettyTable(["姓名","学号","性别"])

插入数据


    table.add_row(["小明","01","男"])
    table.add_row(["小红","02","女"])
    table.add_row(["小黄","03","男"])

显示该表


    print(table)

三、下面是具体的实践：


    #!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')

结果如下：


    =================================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==============================================
    +-----+-------------+------------+----------