Prettytable in PythonIn this tutorial, we will learn to create a relational table using the Python Prettytable module. We will create tables without using external libraries. What is Pretty Table?Pretty tables are the visual representation of the data in tabular forms. These are ASCII tables and easy to use. The prettytable library consists of the PrettyTable class, which is used to create relational tables. To work with this library, we need to install it using the below command. InstallationCreate Table using Pretty TableHere, we will create the row-wise table using the pretty table module. Let’s understand the following example. Example – 1: Creating table row wise Output +--------------+-------+---------+-------+ | Student Name | Class | Subject | Makrs | +--------------+-------+---------+-------+ | Camron | X | English | 91 | | Haris | X | Math | 63 | | Jenny | X | Science | 90 | | Bernald | X | Art | 92 | | Jackson | X | Science | 98 | | Samual | X | English | 88 | | Stark | X | English | 95 | +--------------+-------+---------+-------+ Example – 2: Column Wise Table Output +--------------+-------+---------+-------------------+ | Student Name | Class | Subject | Marks | +--------------+-------+---------+-------------------+ | Jacob | X | English | 91 | | Peter | X | Art | 63 | | Grenger | X | Science | 90 | | Stark | X | Math | 92 | | Falcon | X | Science | 98 | | Matthew | X | English | 83 | | Jackson | X | English | 95 | +--------------+-------+---------+------------------+ We have used the add_column() method of pretty table module. Example – 2: Add Rows in Once Output +--------------+-------+---------+-------+ | Camron | X | English | 91 | | Haris | X | Math | 63 | | Jenny | X | Science | 90 | | Bernald | X | Art | 92 | | Jackson | X | Science | 98 | | Samual | X | English | 88 | | Stark | X | English | 95 | +--------------+-------+---------+-------+ PrettyTable Deleting RowsThis module provides the del_row() method which allows us to removes rows. It takes the index value that to be deleted and remove the rows. The indexing starts from zero. Let’s understand the following code. Example – Output +--------------+-------+---------+-------+ | Student Name | Class | Subject | Makrs | +--------------+-------+---------+-------+ | Camron | X | English | 91 | | Jenny | X | Science | 90 | | Jackson | X | Science | 98 | | Stark | X | English | 95 | +--------------+-------+---------+-------+ It will remove the specific rows from the table. To clear the entire table, we use the following method. Example – 2 Output +--------------+-------+---------+------------------+ | Student Name | Class | Subject | Makrs | +--------------+-------+---------+--------------------+ +--------------+-------+---------+--------------------+ As we can see in the above code, all the rows have been deleted. We can only see the column names. Getting Particular Rows and ColumnsThe main aim of prettytable is to get the tables in ASCII form. We can restrict the output of the table using the following method. Let’s understand the following example. Example: Output +--------------+--------------+ | Student Name | Class | +--------------+--------------+ | Camron | X | | Haris | X | | Jenny | X | | Bernald | X | | Jackson | X | | Samual | X | | Stark | X | +--------------+---------------+ The field argument takes the list of the field names to be printed. We can also use the following method to control the result. Output +--------------+-------+---------+-------------------+ | Student Name | Class | Subject | Makrs | +--------------+-------+---------+-------------------+ | Camron | X | English | 91 | | Haris | X | Math | 63 | | Jenny | X | Science | 90 | +--------------+-------+---------+------------------+ Changing the Alignment of ColumnWe can observe that all the columns in the Table are aligned center. We can change it according to the requirement by assigning one character to align the attribute. There are three strings – ‘l’ (for left), ‘r’ (for right) and ‘c'(for center) alignment, respectively. Let’s see the following example. Example – Output +--------------+-------+---------+-------------------+ | Student Name | Class | Subject | Makrs | +--------------+-------+---------+------------------+ | Camron | X | English | 91 | | Haris | X | Math | 63 | | Jenny | X | Science | 90 | | Bernald | X | Art | 92 | | Jackson | X | Science | 98 | | Samual | X | English | 88 | | Stark | X | English | 95 | +--------------+-------+---------+------------------+ Changing the Appearance of TableThe default table looks like an SQL database shell. However, we can modify the table appearance in the other format. The pretty table module provides the set_style() method, transforming the Table in the MSWord friendly. Let’s see the following example. Example – Add the following code in the create table code. Output | Student Name | Class | Subject | Makrs | | Camron | X | English | 91 | | Haris | X | Math | 63 | | Jenny | X | Science | 90 | | Bernald | X | Art | 92 | | Jackson | X | Science | 98 | | Samual | X | English | 88 | | Stark | X | English | 95 | We can clearly see the difference between the default table and MSWord friendly table. ConclusionWe have discussed some important operations in table using the prettytable module. This is a very effective module to work with table using the Python script. |
原创文章，作者：ItWorker，如若转载，请注明出处：https://blog.ytso.com/263487.html