Spot instance request counts

spot_instances.py

import pandas as pd
from pandas.io.json import json_normalize
import json
import boto3

client = boto3.client('ec2')
data = client.describe_spot_instance_requests()

df = pd.DataFrame(json_normalize(data['SpotInstanceRequests'])).set_index('InstanceId')
df['RequestFailed'] = df['Status.Message'].apply(lambda x: str("unused capacity" in x))
df['InstanceType'] = df['LaunchSpecification.InstanceType']
df['Message'] = df['Status.Message']
df2 = df[ ['InstanceType', 'Message', 'RequestFailed'] ]
print(pd.pivot_table(df2, columns='RequestFailed', index=['InstanceType'], aggfunc='count'))

This dumps count of successful and failed spot instance requests grouped by instance type