How to add multiple values to tabulate array from a range

Question

x = range(98)
for i in x:
    numbers = "{:,}".format(r1["auctions"][(i)]["current_bid"])
    table = [['Title', 'Description', 'Mileage', 'Current Bid'], [r1["auctions"][(i)]["title"], r1["auctions"][(i)]["sub_title"], r1["auctions"][(i)]["mileage"], numbers]]
    print(tabulate(table, headers='firstrow', tablefmt='fancy_grid'))

So current it will print (i)(98) individually but I want all values printed in the same array instead of looping through the range with 1 single data line printed

I don't understand what result you expect. Show it in question (not in comments) — furas, Aug 07 '22 at 11:11
maye you should create list before loop, and `append()` to this list inside loop, and print after loop — furas, Aug 07 '22 at 11:12
you don't need `()` when you get index `[i]` - but code could be even more readable if you would use `for item in r1["auctions"][:98]:` and later `item['title']`, etc. — furas, Aug 07 '22 at 11:14
what if i used a nested list since each car has it's adjacent mileage, desc, current bid. etc? i have to also iterate through a range of 98 since each specific car has an id descending from newest to older (0,98). — , Aug 07 '22 at 11:49
use slice `[0:98]` or shorter `[:98]` to iterate `(0, 98)` - see `for item in r1["auctions"][:98]` — furas, Aug 07 '22 at 12:43

furas · Accepted Answer · 2022-08-07T13:53:53.103

You should do:

before loop you should create list with headers,
inside loop you should append() rows to this list
after loop you should print all as one table

And you could learn to use for-loop without range()

# --- before loop ---

table = [
    ['Title', 'Description', 'Mileage', 'Current Bid']
]

# --- loop ---

for item in r1['auctions'][:98]:
    row = [
        item['title'],
        item['sub_title'],
        item['mileage'],
        '{:,}'.format(item['current_bid']),
    ]
    table.append(row)
    
# --- after loop ---

print(tabulate(table, headers='firstrow', tablefmt='fancy_grid'))

EDIT:

If you have nested data then you need nested for-loops

Minimal code with some random data.

# --- generate random data ---

import random
import json

random.seed(0)  # to generate always the same data

data = []

for model in ['Opel', 'Mercedes', 'Fiat']:

    all_items = []

    for i in range(3):
        item = {
            'title': model,
            'sub_title': random.choice(['Red', 'Green', 'Blue', 'White', 'Black']),
            'mileage': random.randrange(0, 100),
            'current_bid': random.randrange(1000, 10000),
        }
        all_items.append(item)

    data.append({'auctions': all_items})

print(json.dumps(data, indent=2))

# ----------------------------------

from tabulate import tabulate


# --- before loop ---

table = [
    ['Title', 'Description', 'Mileage', 'Current Bid']
]

# --- loop ---

for model in data:

    for item in model['auctions'][:98]:
        row = [
            item['title'],
            item['sub_title'],
            item['mileage'],
            '{:,}'.format(item['current_bid']),
        ]
        table.append(row)

# --- after loop ---

print(tabulate(table, headers='firstrow', tablefmt='fancy_grid', colalign=['left', 'left', 'right', 'right']))

Result:

[
  {
    "auctions": [
      {
        "title": "Opel",
        "sub_title": "White",
        "mileage": 97,
        "current_bid": 7890
      },
      {
        "title": "Opel",
        "sub_title": "Red",
        "mileage": 33,
        "current_bid": 9376
      },
      {
        "title": "Opel",
        "sub_title": "White",
        "mileage": 51,
        "current_bid": 5969
      }
    ]
  },
  {
    "auctions": [
      {
        "title": "Mercedes",
        "sub_title": "White",
        "mileage": 45,
        "current_bid": 4578
      },
      {
        "title": "Mercedes",
        "sub_title": "Black",
        "mileage": 17,
        "current_bid": 5617
      },
      {
        "title": "Mercedes",
        "sub_title": "Green",
        "mileage": 96,
        "current_bid": 2553
      }
    ]
  },
  {
    "auctions": [
      {
        "title": "Fiat",
        "sub_title": "Black",
        "mileage": 32,
        "current_bid": 9725
      },
      {
        "title": "Fiat",
        "sub_title": "Black",
        "mileage": 18,
        "current_bid": 6081
      },
      {
        "title": "Fiat",
        "sub_title": "Red",
        "mileage": 93,
        "current_bid": 2208
      }
    ]
  }
]

╒══════════╤═══════════════╤═══════════╤═══════════════╕
│ Title    │ Description   │   Mileage │   Current Bid │
╞══════════╪═══════════════╪═══════════╪═══════════════╡
│ Opel     │ White         │        97 │         7,890 │
├──────────┼───────────────┼───────────┼───────────────┤
│ Opel     │ Red           │        33 │         9,376 │
├──────────┼───────────────┼───────────┼───────────────┤
│ Opel     │ White         │        51 │         5,969 │
├──────────┼───────────────┼───────────┼───────────────┤
│ Mercedes │ White         │        45 │         4,578 │
├──────────┼───────────────┼───────────┼───────────────┤
│ Mercedes │ Black         │        17 │         5,617 │
├──────────┼───────────────┼───────────┼───────────────┤
│ Mercedes │ Green         │        96 │         2,553 │
├──────────┼───────────────┼───────────┼───────────────┤
│ Fiat     │ Black         │        32 │         9,725 │
├──────────┼───────────────┼───────────┼───────────────┤
│ Fiat     │ Black         │        18 │         6,081 │
├──────────┼───────────────┼───────────┼───────────────┤
│ Fiat     │ Red           │        93 │         2,208 │
╘══════════╧═══════════════╧═══════════╧═══════════════╛

I added example with nested `for`-loops. I don't have your data so I generated own data to show how it works. Your data may have different structure and it may need different `for`-loops. — furas, Aug 07 '22 at 13:59

How to add multiple values to tabulate array from a range

1 Answers1