How would I make the output into a table?

Question

I would like the output to be table. Without the curly brackets and double quotes. Can I get some help with this? I'm using python 3.7.5

students = [ 
  { "grade": 5,
    "firstname": "Brendon", 
    "lastname": "Urie", 
    "gender": "M" 
    },
  { 
    "grade": 7,
    "firstname": "Freddy",
    "lastname": "Mercury",
    "gender": "M" 
  },
  { 
    "grade": 12,
    "firstname": "Tessa",
    "lastname": "Thompson"
  }
]

output("list", students, None)

Please share the expected output, as in what type of data structure are you hoping, a string formatted like a table? — Dani Mesejo, Oct 19 '19 at 14:58
Related question: https://stackoverflow.com/questions/9535954/printing-lists-as-tabular-data — ascripter, Oct 19 '19 at 15:00

score 1 · Answer 1 · answered Oct 19 '19 at 15:09

You can use the pandas to print it as dataframe.

import pandas as pd

students = [ 
    { 
        "grade":5,
        "firstname":"Brendon",
        "lastname":"Urie",
        "gender":"M"
    },
    { 
        "grade":7,
        "firstname":"Freddy",
        "lastname":"Mercury",
        "gender":"M"
    },
    { 
        "grade":12,
        "firstname":"Tessa",
        "lastname":"Thompson"
    }
]

df = pd.DataFrame(students)
df

The result is:

    firstname   gender  grade   lastname
0   Brendon M   5   Urie
1   Freddy  M   7   Mercury
2   Tessa   NaN 12  Thompson

score 0 · Answer 2 · answered Oct 19 '19 at 14:58

0

If you mean tables for terminal terminaltables is just what you need :

https://robpol86.github.io/terminaltables/

answered Oct 19 '19 at 14:58

Loïc

11,804
1
31
49

score 0 · Answer 3 · answered Oct 19 '19 at 15:50

You can pretty-print dictionary as tables using tabulate

from tabulate import tabulate

def dict_to_list(lst):
  """ Converts students to list of the form 
[[5, 'Brendon', 'Urie', 'M'], [7, 'Freddy', 'Mercury', 'M'], ...] """
  return [[v for v in d.values()] for d in lst]

students = [ 
  { "grade": 5,
    "firstname": "Brendon", 
    "lastname": "Urie", 
    "gender": "M" 
    },
  { 
    "grade": 7,
    "firstname": "Freddy",
    "lastname": "Mercury",
    "gender": "M" 
  },
  { 
    "grade": 12,
    "firstname": "Tessa",
    "lastname": "Thompson"
  }
]

# tabulate takes as input: list of lists, and header
# list of list = dict_to_list(students)
# header = students[0].keys()
print (tabulate(dict_to_list(students), students[0].keys()))

Output (pretty format with columns aligned)

 grade  firstname    lastname    gender
-------  -----------  ----------  --------
      5  Brendon      Urie        M
      7  Freddy       Mercury     M
     12  Tessa        Thompson

How would I make the output into a table?

3 Answers3