Python to produce nice tabular output

How about using format...  (https://www.programiz.com/python-programming/methods/string/format )
Then use for heading & data:

...
template="{10} {14} {40} {16.10} {6} {10}"
...
print(template.format("TimePeriod", "LinkedAccount", "Service", "Amount", "Unit", "Estimated"))
...
   print(template.format(result_by_time['TimePeriod']['Start'], group['Keys']['LINKED_ACCOUNT'],  group['Keys']['SERVICE'], amount, unit,  result_by_time['Estimated']))
...

Select allOpen in new window

You still need the subfields for the keys to be corrected i guessed them from the source.

The format might need a bit of adjustment. I guessed the widths from the above example.

Thanks a lot Noci, will update you

Sorry, this is what I updated. since i'm not familiar with python

#!/usr/bin/env python3

import argparse
import boto3
import datetime

parser = argparse.ArgumentParser()
parser.add_argument('--days', type=int, default=30)
args = parser.parse_args()


now = datetime.datetime.utcnow()
start = (now - datetime.timedelta(days=args.days)).strftime('%Y-%m-%d')
end = now.strftime('%Y-%m-%d')
template="{10} {14} {40} {16.10} {6} {10}"

cd = boto3.client('ce', 'ap-southeast-2')

results = []

token = None
while True:
    if token:
        kwargs = {'NextPageToken': token}
    else:
        kwargs = {}
    data = cd.get_cost_and_usage(TimePeriod={'Start': start, 'End':  end}, Granularity='DAILY', Metrics=['UnblendedCost'], GroupBy=[{'Type': 'DIMENSION', 'Key': 'LINKED_ACCOUNT'}, {'Type': 'DIMENSION', 'Key': 'SERVICE'}], **kwargs)
    results += data['ResultsByTime']
    token = data.get('NextPageToken')
    if not token:
        break

# print('\t'.join(['TimePeriod', 'LinkedAccount', 'Service'.ljust(40, ' '), 'Amount', 'Unit', 'Estimated']))
print(template.format("TimePeriod", "LinkedAccount", "Service", "Amount", "Unit", "Estimated")

for result_by_time in results:
    for group in result_by_time['Groups']:
        amount = group['Metrics']['UnblendedCost']['Amount']
        unit = group['Metrics']['UnblendedCost']['Unit']
        # comp = join(group['Keys'])
        # rep_start_time = result_by_time['TimePeriod']['Start']
        # print(rep_start_time.ljust(10, ' '), '\t', '\t' .join(group['Keys']), '\t', '\t', '\t', amount.rjust(30, ' '), '\t', unit, '\t', result_by_time['Estimated'])
        print(template.format(result_by_time['TimePeriod']['Start'], group['Keys'],  amount, '\t', unit, '\t', result_by_time['Estimated'])

Select allOpen in new window

Error

./aws-cost-and-usage-report.py --days=7
Traceback (most recent call last):
  File "./aws-cost-and-usage-report.py", line 34, in <module>
    print(template.format("TimePeriod", "LinkedAccount", "Service", "Amount", "Unit", "Estimated"))
IndexError: tuple index out of range

Select allOpen in new window

there are missing ) with the print statements.  And i removed the '\t' from the 2nd string.
(I copied a wrong example earlier...)
(add : in the formats type field for float, and difference between header & data template)

#!/usr/bin/env python3

import argparse
import boto3
import datetime

parser = argparse.ArgumentParser()
parser.add_argument('--days', type=int, default=30)
args = parser.parse_args()


now = datetime.datetime.utcnow()
start = (now - datetime.timedelta(days=args.days)).strftime('%Y-%m-%d')
end = now.strftime('%Y-%m-%d')
dtemplate="{:10} {:14} {:40} {:16.10f} {:6} {:10}"
htemplate="{:10} {:14} {:40} {:16} {:6} {:10}"

cd = boto3.client('ce', 'ap-southeast-2')

results = []

token = None
while True:
    if token:
        kwargs = {'NextPageToken': token}
    else:
        kwargs = {}
    data = cd.get_cost_and_usage(TimePeriod={'Start': start, 'End':  end}, Granularity='DAILY', Metrics=['UnblendedCost'], GroupBy=[{'Type': 'DIMENSION', 'Key': 'LINKED_ACCOUNT'}, {'Type': 'DIMENSION', 'Key': 'SERVICE'}], **kwargs)
    results += data['ResultsByTime']
    token = data.get('NextPageToken')
    if not token:
        break

# print('\t'.join(['TimePeriod', 'LinkedAccount', 'Service'.ljust(40, ' '), 'Amount', 'Unit', 'Estimated']))
print(htemplate.format("TimePeriod", "LinkedAccount", "Service", "Amount", "Unit", "Estimated"))

for result_by_time in results:
    for group in result_by_time['Groups']:
        amount = group['Metrics']['UnblendedCost']['Amount']
        unit = group['Metrics']['UnblendedCost']['Unit']
        # comp = join(group['Keys'])
        # rep_start_time = result_by_time['TimePeriod']['Start']
        # print(rep_start_time.ljust(10, ' '), '\t', '\t' .join(group['Keys']), '\t', '\t', '\t', amount.rjust(30, ' '), '\t', unit, '\t', result_by_time['Estimated'])
        print(dtemplate.format(result_by_time['TimePeriod']['Start'], group['Keys']['LINKED_ACCOUNT'],  group['Keys']['SERVICE'], amount, unit,  result_by_time['Estimated']))

Select allOpen in new window

Why don't use pandas DataFrame?

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.html#pandas.DataFrame

Hi,
You can using one of the modules:

https://pypi.org/project/tabulate/

or

https://pypi.org/project/tabulate/
ex: print(tabulate(table, headers, tablefmt="pipe"))

or

https://pypi.org/project/beautifultable/

Hi noci, sorry again.

kindly help pls

./aws-cost-and-usage-report.py
TimePeriod LinkedAccount  Service                                  Amount           Unit   Estimated
Traceback (most recent call last):
  File "./aws-cost-and-usage-report.py", line 44, in <module>
    print(dtemplate.format(result_by_time['TimePeriod']['Start'], group['Keys']['LINKED_ACCOUNT'],  group['Keys']['SERVICE'], amount, unit,  result_by_time['Estimated']))
TypeError: list indices must be integers or slices, not str

Thanks Juan and Suhas,
I tried these as a standalone scripts it works fine.

My challenge is how to incorporate this to my script :)

The group['Keys]['LINKED_ACCOUNT] & group['Keys']['SERVICE'] probably are not strings. This might need to be changed to:

 group['Keys][0] & group['Keys'][1]

print(dtemplate.format(result_by_time['TimePeriod']['Start'], group['Keys'][0],  group['Keys'][1], amount, unit,  result_by_time['Estimated']))

Select allOpen in new window

I have no access to AWS so i cannot verify the code.

its ok, I can understand....thx for your help

may be we are getting close :)


./aws-cost-and-usage-report.py

TimePeriod LinkedAccount  Service                                  Amount           Unit   Estimated
Traceback (most recent call last):
  File "./aws-cost-and-usage-report.py", line 45, in <module>
    print(dtemplate.format(result_by_time['TimePeriod']['Start'], group['Keys'][0],  group['Keys'][1], amount, unit,  result_by_time['Estimated']))
ValueError: Unknown format code 'f' for object of type 'str'

Select allOpen in new window

Thanks a lot Noci, you are simply great!

Even though you did not have the aws env...you helped me. :)