import matplotlib.pyplot as plt
import numpy as np
import pandas as pd


df = pd.read_csv('transcount.csv')
df = df.groupby('year').aggregate(np.mean)

gpu = pd.read_csv('gpu_transcount.csv')
gpu = gpu.groupby('year').aggregate(np.mean)

df = pd.merge(df, gpu, how='outer', left_index=True, right_index=True)
df = df.replace(np.nan, 0)
df.plot()
df.plot(logy=True)
df[df['gpu_trans_count'] > 0].plot(kind='scatter', x='trans_count', y='gpu_trans_count', loglog=True)
plt.show()

[((6, 5, 6, 34), 'pandas.read_csv', 'pd.read_csv', ({(6, 17, 6, 33): '"""transcount.csv"""'}, {}), "('transcount.csv')", True, 'import pandas as pd\n'), ((9, 6, 9, 39), 'pandas.read_csv', 'pd.read_csv', ({(9, 18, 9, 38): '"""gpu_transcount.csv"""'}, {}), "('gpu_transcount.csv')", True, 'import pandas as pd\n'), ((12, 5, 12, 70), 'pandas.merge', 'pd.merge', (), '', True, 'import pandas as pd\n'), ((17, 0, 17, 10), 'matplotlib.pyplot.show', 'plt.show', ({}, {}), '()', True, 'import matplotlib.pyplot as plt\n')]