Python script to tabulate data formats like json, csv, html, etc

Last update: Dec 30, 2021

Related tags

Command-line Tools pyT

Overview

pyT

PyT is a a command line tool and as well a library for visualising various data formats like:

JSON
HTML Table
CSV
XML, etc.

Features

Print table of any size without distortions.
Support multiple file formats.
Better presentation of various data structures, types.

Usage

JSON data

{
  "squadName": "Super hero squad",
  "homeTown": "Metro City",
  "formed": 2016,
  "secretBase": "Super tower",
  "active": true,
  "members": [
    {
      "name": "Molecule Man",
      "age": 29,
      "secretIdentity": "Dan Jukes",
      "powers": "Turning tiny"
    },
    {
      "name": "Madame Uppercut",
      "age": 39,
      "secretIdentity": "Jane Wilson",
      "powers": "Million punch"
    },
    {
      "name": "Eternal Flame",
      "age": 1000000,
      "secretIdentity": "Unknown",
      "powers": "Immortality"
    }
  ]
}

import pyT.Table as table
table = Table(*item["members"])
json_table.draw()

JSON file

import pyT.Table as table
json = table.JSON('./tab.json', "members")
json_table = Table(*json)
json_table.draw()

Output

+----------------+----------------+----------------+----------------+
|      name      |      age       | secretIdentity |     powers     |
+----------------+----------------+----------------+----------------+
|  Molecule Man  |       29       |   Dan Jukes    |  Turning tiny  |
+----------------+----------------+----------------+----------------+
|Madame Uppercut |       39       |  Jane Wilson   | Million punch  |
+----------------+----------------+----------------+----------------+
| Eternal Flame  |    1000000     |    Unknown     |  Immortality   |
+----------------+----------------+----------------+----------------+

HTML

Name and surname Profession Salary Mobolaji Abdsalam Elect Technician 55,000 Ibraheem Abdsalam Software Engineer 700,000 IBM Abdsalam Elect Engineer 500, 000 Mobolaji Abdsalam Elect. Technician 55, 000 Ibraheem Abdsalam Software Engineer 700, 000 IBM Abdsalam Elect Engineer 500, 000 ">

 <!doctype html>
    <head>
    </head>
    <body>
        <table border = "1" cellpadding = "5" cellspacing = "5">
             <tr>
                <th>Name and surname</th>
                <th>Profession</th>
                <th>Salary</th>
             </tr>
             <tr>
                <td>Mobolaji Abdsalam</td>
                <td>Elect Technician</td>
                <td>55,000</td>
             </tr>
             <tr>
                <td>Ibraheem Abdsalam</td>
                <td>Software Engineer</td>
                <td>700,000</td>
             </tr>
             <tr>
                <td>IBM Abdsalam</td>
                <td>Elect Engineer</td>
                <td>500, 000</td>
             </tr>
             <tr>
                <td>Mobolaji Abdsalam</td>
                <td>Elect. Technician</td>
                <td>55, 000</td>
             </tr>
             <tr>
                <td>Ibraheem Abdsalam</td>
                <td>Software Engineer</td>
                <td>700, 000</td>
             </tr>
             <tr>
                <td>IBM Abdsalam</td>
                <td>Elect Engineer</td>
                <td>500, 000</td>
             </tr>
        </table>
    </body>
</html>

HTML file

import pyT.Table as table
html = table.HTML('./tab.html', n=0)# n specifies which table to be parsed and rendered.
n = 0 => First table on the page.
n = 1 => Second table on the page.
html_table = Table(*html)
html_table.draw()

Output

+------------------+------------------+------------------+
| Name and surname |    Profession    |      Salary      |
+------------------+------------------+------------------+
|Mobolaji Abdsalam | Elect Technician |      55,000      |
+------------------+------------------+------------------+
|Ibraheem Abdsalam |Software Engineer |     700,000      |
+------------------+------------------+------------------+
|   IBM Abdsalam   |  Elect Engineer  |     500, 000     |
+------------------+------------------+------------------+
|Mobolaji Abdsalam |Elect. Technician |     55, 000      |
+------------------+------------------+------------------+
|Ibraheem Abdsalam |Software Engineer |     700, 000     |
+------------------+------------------+------------------+
|   IBM Abdsalam   |  Elect Engineer  |     500, 000     |
+------------------+------------------+------------------+

Python script to tabulate data formats like json, csv, html, etc

Related tags

Overview

pyT

Features

Usage

JSON data

JSON file

Output

HTML

HTML file

Output

Owner

Mobolaji Abdulsalam

Chameleon is yet another PowerShell obfuscation tool designed to bypass AMSI and commercial antivirus solutions.

'rl_UK' is an open-source command-line tool in Python for calculating the shortest path between BUS stop sequences in the UK

Bear-Shell is a shell based in the terminal or command prompt.

Helping you manage your data science projects sanely.

inklayers is a command line program that exports layers from an SVG file.

A CLI for streaming, downloading anime shows. The shows data is indexed through GogoAnime.

Termtyper is a TUI typing application that provides you a great feel with typing with a lot of options to tweak

Gitfetch is a simple tool to get github user details

xonsh is a Python-powered, cross-platform, Unix-gazing shell

A simple terminal-based localhost chat application written in python

Skiller - With this payload you can control the target computer with (cmd)

🎮 An easy to use tool to change the mapping of your input device buttons.

A simple note taker CLI program written in python

Command line interface for testing internet bandwidth using speedtest.net

Display Images in your terminal with python

A CLI folder organizer written in Python.

A cli tool , which shows you all the next possible words you can guess from in the game of Wordle.

Chat In Terminal - Chat-App in python

A command line application, written in Python, for interacting with Spotify.

Use case: quick JSON processing/restructuring with jq without terminal

Python script to tabulate data formats like json, csv, html, etc

Related tags

Overview

pyT

Features

Usage

JSON data

JSON file

Output

HTML

HTML file

Output

Owner

Mobolaji Abdulsalam

Chameleon is yet another PowerShell obfuscation tool designed to bypass AMSI and commercial antivirus solutions.

'rl_UK' is an open-source command-line tool in Python for calculating the shortest path between BUS stop sequences in the UK

Bear-Shell is a shell based in the terminal or command prompt.

Helping you manage your data science projects sanely.

inklayers is a command line program that exports layers from an SVG file.

A CLI for streaming, downloading anime shows. The shows data is indexed through GogoAnime.

Termtyper is a TUI typing application that provides you a great feel with typing with a lot of options to tweak

Gitfetch is a simple tool to get github user details

xonsh is a Python-powered, cross-platform, Unix-gazing shell

A simple terminal-based localhost chat application written in python

Skiller - With this payload you can control the target computer with (cmd)

🎮 An easy to use tool to change the mapping of your input device buttons.

A simple note taker CLI program written in python

Command line interface for testing internet bandwidth using speedtest.net

Display Images in your terminal with python

A **CLI** folder organizer written in Python.

A cli tool , which shows you all the next possible words you can guess from in the game of Wordle.

Chat In Terminal - Chat-App in python

A command line application, written in Python, for interacting with Spotify.

Use case: quick JSON processing/restructuring with jq without terminal

A CLI folder organizer written in Python.