describe ec2 instance, per aws (cli) profile, per region, print the instance id, instance type and instance state (running/stop/etc) in csv format

describe_instance.py

import boto3
from pprint import pprint


profiles = ['default']
regions = [region['RegionName'] for region in boto3.client('ec2', region_name='us-east-1').describe_regions()['Regions']]

print('profile,region,instance_id,instance_type,instance_state')
for profile in profiles:
    for region in regions:
        session = boto3.Session(profile_name=profile)
        client = session.client('ec2', region_name=region)
        instances = client.describe_instances()
        output = instances['Reservations']
        if output:
            for instance_list in output:
                for instance in instance_list['Instances']:
                    instance_id = instance['InstanceId']
                    instance_type = instance['InstanceType']
                    instance_state = instance['State']['Name']
                    print(f'{profile},{region},{instance_id},{instance_type},{instance_state}')