df_joinedQGDP['Date']=df_joinedQGDP["Date"].str.replace('-','')
#deleting the hyphen in "date" (replacing it with nothing), same for commas below
df_joinedQGDP['QGDP']=df_joinedQGDP["QGDP"].str.replace(',','')
df_joinedQGDP['QGDP']=pd.to_numeric(df_joinedQGDP["QGDP"],errors='coerce')
#to_numeric in pandas turns everything into an integer, but just deletes errors

df_joinedQGDP['Date']=df_joinedQGDP["Date"].astype(int)
df_joinedQGDP=df_joinedQGDP.dropna()
df_joinedQGDP