import google import matplotlib.pyplot as plt import numpy as np code="1zWKwJoa78A0RKGyqAvpmBKymyLwmV0mHd9_zSBo7lSs" sub=google.google() ws=sub.worksh(code,0) sub2=google.google() sub2.catchdata(code,ws) v=sub2.v x=sub2.x y=sub2.y z=[] year=[] for i in range(len(v)): if x[i]==2: z.append(v[i]) if x[i]==1: year.append(v[i]) t=[] for x1 in year: x2=int(x1) t.append(x2) z1=[] for i in range(len(year)): z1.append(float(z[i+1])) plt.plot(t, z1) plt.show()