Python Forum
making variables in my columns and rows in python
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
making variables in my columns and rows in python
#3
Add first data i structure eg list, dictionary.
Then can use f-string or eg python-tabulate.
Don't use old string formatting anymore %ds % .
Example.
from tabulate import tabulate

item = 'Milk'
price = 100
quantity = 5
total = 500
item_lst = []
item_lst.append(item)
item_lst.append(price)
item_lst.append(quantity)
item_lst.append(total)

lst = []
header = ['Item', 'Price', 'Quantity', 'Total']
lst.append(header)
lst.append(item_lst)

# f-string
for inner in lst:
    print(''.join((f"{word:<10}" for word in inner)))
print('-' * 35)

# python-tabulate
print(tabulate(lst))
print(tabulate(lst, tablefmt="fancy_grid"))
print(tabulate(lst, tablefmt="github"))
Output:
Item Price Quantity Total Milk 100 5 500 ----------------------------------- ---- ----- -------- ----- Item Price Quantity Total Milk 100 5 500 ---- ----- -------- ----- ╒══════╤═══════╤══════════╤═══════╕ │ Item │ Price │ Quantity │ Total │ ├──────┼───────┼──────────┼───────┤ │ Milk │ 100 │ 5 │ 500 │ ╘══════╧═══════╧══════════╧═══════╛ |------|-------|----------|-------| | Item | Price | Quantity | Total | | Milk | 100 | 5 | 500 |
Also eg Pandas easier to manipulate data eg NoteBook.
Reply


Messages In This Thread
RE: making variables in my columns and rows in python - by snippsat - Oct-31-2021, 10:38 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to store columns of a .csv in variables (when the .csv has no headers) ? hobbyist 6 1,381 Aug-18-2023, 02:06 PM
Last Post: deanhystad
  Converting a json file to a dataframe with rows and columns eyavuz21 13 4,854 Jan-29-2023, 03:59 PM
Last Post: eyavuz21
  How to properly format rows and columns in excel data from parsed .txt blocks jh67 7 1,991 Dec-12-2022, 08:22 PM
Last Post: jh67
  Check DataFrames with different sorting in columns and rows Foxyskippy 0 816 Nov-19-2022, 07:49 AM
Last Post: Foxyskippy
  The code I have written removes the desired number of rows, but wrong rows Jdesi1983 0 1,656 Dec-08-2021, 04:42 AM
Last Post: Jdesi1983
  rows from sql query need to write to a file as columns sjcsvatt 6 2,502 Oct-09-2021, 12:45 AM
Last Post: snippsat
  Merging spreadsheets with the same columns and extracting rows with matching entries johnbernard 3 11,015 Aug-19-2021, 03:08 PM
Last Post: johnbernard
  Summing up rows and columns plumberpy 3 2,329 Aug-18-2021, 05:46 AM
Last Post: naughtyCat
  Pandas DataFrame combine rows by column value, where Date Rows are NULL rhat398 0 2,157 May-04-2021, 10:51 PM
Last Post: rhat398
  Indexing [::-1] to Reverse ALL 2D Array Rows, ALL 3D, 4D Array Columns & Rows Python Jeremy7 8 7,341 Mar-02-2021, 01:54 AM
Last Post: Jeremy7

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020