Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- print ("""
- Name ID Email
- --------------------------------------------------""")
- data = [["Suresh Datta", 57394, "suresh@example.com"], ["Colette Browning", 48539, "colette@example.com"], ["Skye Homsi", 58302, "skye@example.com"], ["Hiroto Yamaguchi", 48502, "hiroto@example.com"], ["Tobias Ledford", 48291, "tobias@example.com"], ["Tamara Babic", 58201, "tamara@example.com"], ["Jin Xu", 48293, "jin@example.com"], ["Joana Dias", 23945, "joana@example.com"], ["Alton Derosa", 85823, "alton@example.com"]]
- for row in data:
- for col in row:
- print ("%s t %f t %s" % (col, col,col, col,col, col,col, col,col, col,col, col,col, col,col, col,col, col,col, col,col, col,col, col))
- print("""
- Name ID Email
- --------------------------------------------------""")
- for row in data:
- print("{} t {} t {}".format(*row))
- # pip install tabulate
- from tabulate import tabulate
- print(tabulate(data, headers=['Name', 'ID', 'Email'], tablefmt="grid"))
- +------------------+-------+---------------------+
- | Name | ID | Email |
- +==================+=======+=====================+
- | Suresh Datta | 57394 | suresh@example.com |
- +------------------+-------+---------------------+
- | Colette Browning | 48539 | colette@example.com |
- +------------------+-------+---------------------+
- | Skye Homsi | 58302 | skye@example.com |
- +------------------+-------+---------------------+
- | Hiroto Yamaguchi | 48502 | hiroto@example.com |
- +------------------+-------+---------------------+
- | Tobias Ledford | 48291 | tobias@example.com |
- +------------------+-------+---------------------+
- | Tamara Babic | 58201 | tamara@example.com |
- +------------------+-------+---------------------+
- | Jin Xu | 48293 | jin@example.com |
- +------------------+-------+---------------------+
- | Joana Dias | 23945 | joana@example.com |
- +------------------+-------+---------------------+
- | Alton Derosa | 85823 | alton@example.com |
- +------------------+-------+---------------------+
- import pandas as pd # pip install pandas
- df = pd.DataFrame(data, columns=['Name','ID','Email'])
- print(df)
- Name ID Email
- 0 Suresh Datta 57394 suresh@example.com
- 1 Colette Browning 48539 colette@example.com
- 2 Skye Homsi 58302 skye@example.com
- 3 Hiroto Yamaguchi 48502 hiroto@example.com
- 4 Tobias Ledford 48291 tobias@example.com
- 5 Tamara Babic 58201 tamara@example.com
- 6 Jin Xu 48293 jin@example.com
- 7 Joana Dias 23945 joana@example.com
- 8 Alton Derosa 85823 alton@example.com
- In [73]: print(df[df['Name'].str.contains(r'(?:Tamara|Joana)')].sort_values('ID'))
- Name ID Email
- 7 Joana Dias 23945 joana@example.com
- 5 Tamara Babic 58201 tamara@example.com
- In [89]: for row in data:
- ...: print("{:>20} {:>10} {:>30}".format(*row))
- ...:
- ...:
- Suresh Datta 57394 suresh@example.com
- Colette Browning 48539 colette@example.com
- Skye Homsi 58302 skye@example.com
- Hiroto Yamaguchi 48502 hiroto@example.com
- Tobias Ledford 48291 tobias@example.com
- Tamara Babic 58201 tamara@example.com
- Jin Xu 48293 jin@example.com
- Joana Dias 23945 joana@example.com
- Alton Derosa 85823 alton@example.com
Add Comment
Please, Sign In to add comment