Terraform vs CloudFormation new resources added 2018-04-01 to 2019-04-30. See stuartsandine.com/terraform-vs-cloudformation-aws-resource-support

analyze.py

import datetime
import matplotlib.pyplot as plt
import pandas as pd
import numpy as np
from wordcloud import WordCloud
import squarify

df = pd.read_csv('./tf-vs-cfn.csv', parse_dates=[1,2], infer_datetime_format=True)

cfn_added_support_during_year = df[df['CFN date'] >= datetime.datetime(2018, 4, 1)]
tf_added_support_during_year = df[df['TF date'] >= datetime.datetime(2018, 4, 1)]

cfn_and_not_tf = cfn_added_support_during_year[cfn_added_support_during_year['TF date'].isnull()]
tf_and_not_cfn = tf_added_support_during_year[tf_added_support_during_year['CFN date'].isnull()]

# add a new column `delta` which represents the time difference between CFN and
# CFN support being added for a given resource.
# a negative number means CFN support came first, positive means TF support came first.
resources_both_tools_support = df[df['CFN date'].notnull() & df['TF date'].notnull()]
delta = resources_both_tools_support['CFN date'] - resources_both_tools_support['TF date']
resources_both_tools_support['delta'] = delta

same_day_support_added = resources_both_tools_support[resources_both_tools_support['delta'].dt.days == 0]
cfn_supported_first = resources_both_tools_support[resources_both_tools_support['delta'].dt.days < 0]
tf_supported_first = resources_both_tools_support[resources_both_tools_support['delta'].dt.days > 0]

cfn_only_services = [ r.split('::')[1] for r in cfn_and_not_tf['resource'].values ]
tf_only_services = [ r.split('_')[1] for r in tf_and_not_cfn['resource'].values ]

def save_wordcloud(filename, words):
    wordcloud = WordCloud(regexp=r'\w+', width=600, height=400, background_color='white', collocations=False).generate(' '.join(words))
    image = wordcloud.to_image()
    image.save(filename)

def save_treemap(filename, df):
    # filter out the zeroes
    # df = df[df['delta'].dt.days != 0]
    # colors = np.where(df['delta'].dt.days < 0, 'red', 'blue')
    # squarify.plot(sizes=df['delta'].dt.days.values / 85, label=df['resource'].values, color=colors)
    squarify.plot(sizes=df['delta'].dt.days.values, label=df['resource'].values)
    plt.axis('off')
    plt.savefig(filename)
    plt.clf()


def save_diverging_bar(filename, df):
    df['colors'] = ['orange' if d < 0 else 'purple' for d in df['delta'].dt.days]
    df.sort_values('resource', inplace=True)
    df.reset_index(inplace=True)
    # colors = np.where(df['delta'].dt.days < 0, 'red', 'blue')

    # Draw plot
    plt.figure(figsize=(18,18))
    plt.hlines(y=df.index, xmin=0, xmax=df.delta.dt.days.values)
    for x, y, tex in zip(df.delta.dt.days.values, df.index, df.delta.dt.days.values):
        t = plt.text(x, y, abs(round(tex, 2)), horizontalalignment='right' if x < 0 else 'left', verticalalignment='center', fontdict={'color':'orange' if x < 0 else 'purple', 'size':14})

    # Decorations    
    plt.yticks(df.index, df.resource, fontsize=10)
    plt.grid(linestyle='--', alpha=0.5)
    # plt.xlim(-2.5, 5)
    plt.subplots_adjust(left=0.23)
    plt.savefig(filename)
    plt.clf()


if __name__ == '__main__':
    print(f'total number of AWS resources for which at least one tool added support: {len(df)}')
    print(f'CFN added support for {len(cfn_added_support_during_year)} AWS resources')
    print(f'TF added support for {len(tf_added_support_during_year)} AWS resources')
    print(f'CFN added support for {len(cfn_and_not_tf)} AWS resources that TF does not support')
    print(f'TF added support for {len(tf_and_not_cfn)} AWS resources that CFN does not support')
    print(f'CFN and TF added support for {len(same_day_support_added)} AWS resources on the same day')
    print(f'both tools support and CFN added support first:\n{cfn_supported_first.describe()}')
    print(f'both tools support and TF added support first:\n{tf_supported_first.describe()}')
    save_wordcloud('cfn-wordcloud.png', cfn_only_services)
    save_wordcloud('tf-wordcloud.png', tf_only_services)
    save_wordcloud('cfn-first-wordcloud.png', cfn_supported_first['resource'].values)
    save_wordcloud('tf-first-wordcloud.png', tf_supported_first['resource'].values)
    # save_treemap('tf-treemap.png', cfn_supported_first)
    save_diverging_bar('diverging.png', resources_both_tools_support)

cf-vs-tfn.csv