Guest User

Untitled

a guest
Aug 9th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.50 KB | None | 0 0
  1. print ("""
  2. Name ID Email
  3. --------------------------------------------------""")
  4.  
  5.  
  6. data = [["Suresh Datta", 57394, "[email protected]"], ["Colette Browning", 48539, "[email protected]"], ["Skye Homsi", 58302, "[email protected]"], ["Hiroto Yamaguchi", 48502, "[email protected]"], ["Tobias Ledford", 48291, "[email protected]"], ["Tamara Babic", 58201, "[email protected]"], ["Jin Xu", 48293, "[email protected]"], ["Joana Dias", 23945, "[email protected]"], ["Alton Derosa", 85823, "[email protected]"]]
  7.  
  8. for row in data:
  9. for col in row:
  10. 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))
  11.  
  12. print("""
  13. Name ID Email
  14. --------------------------------------------------""")
  15.  
  16. for row in data:
  17. print("{} t {} t {}".format(*row))
  18.  
  19. # pip install tabulate
  20. from tabulate import tabulate
  21. print(tabulate(data, headers=['Name', 'ID', 'Email'], tablefmt="grid"))
  22.  
  23. +------------------+-------+---------------------+
  24. | Name | ID | Email |
  25. +==================+=======+=====================+
  26. | Suresh Datta | 57394 | [email protected] |
  27. +------------------+-------+---------------------+
  28. | Colette Browning | 48539 | [email protected] |
  29. +------------------+-------+---------------------+
  30. | Skye Homsi | 58302 | [email protected] |
  31. +------------------+-------+---------------------+
  32. | Hiroto Yamaguchi | 48502 | [email protected] |
  33. +------------------+-------+---------------------+
  34. | Tobias Ledford | 48291 | [email protected] |
  35. +------------------+-------+---------------------+
  36. | Tamara Babic | 58201 | [email protected] |
  37. +------------------+-------+---------------------+
  38. | Jin Xu | 48293 | [email protected] |
  39. +------------------+-------+---------------------+
  40. | Joana Dias | 23945 | [email protected] |
  41. +------------------+-------+---------------------+
  42. | Alton Derosa | 85823 | [email protected] |
  43. +------------------+-------+---------------------+
  44.  
  45. import pandas as pd # pip install pandas
  46.  
  47. df = pd.DataFrame(data, columns=['Name','ID','Email'])
  48.  
  49. print(df)
  50.  
  51. Name ID Email
  52. 0 Suresh Datta 57394 [email protected]
  53. 1 Colette Browning 48539 [email protected]
  54. 2 Skye Homsi 58302 [email protected]
  55. 3 Hiroto Yamaguchi 48502 [email protected]
  56. 4 Tobias Ledford 48291 [email protected]
  57. 5 Tamara Babic 58201 [email protected]
  58. 6 Jin Xu 48293 [email protected]
  59. 7 Joana Dias 23945 [email protected]
  60. 8 Alton Derosa 85823 [email protected]
  61.  
  62. In [73]: print(df[df['Name'].str.contains(r'(?:Tamara|Joana)')].sort_values('ID'))
  63. Name ID Email
  64. 7 Joana Dias 23945 [email protected]
  65. 5 Tamara Babic 58201 [email protected]
  66.  
  67. In [89]: for row in data:
  68. ...: print("{:>20} {:>10} {:>30}".format(*row))
  69. ...:
  70. ...:
  71. Suresh Datta 57394 [email protected]
  72. Colette Browning 48539 [email protected]
  73. Skye Homsi 58302 [email protected]
  74. Hiroto Yamaguchi 48502 [email protected]
  75. Tobias Ledford 48291 [email protected]
  76. Tamara Babic 58201 [email protected]
  77. Jin Xu 48293 [email protected]
  78. Joana Dias 23945 [email protected]
  79. Alton Derosa 85823 [email protected]
Add Comment
Please, Sign In to add comment