Append dictionary to pandas dataframe in a loop
You need:
df = pd.DataFrame([podcast_dict], columns=podcast_dict.keys())
df_podcast = pd.concat([df_podcast, df], axis =0).reset_index()
If you want to simply append new data from a created dictionary within a loop to an existening Dataframe:
df = pd.DataFrame()
for i in range(n):
dict_new = dict(i)
df = df.append(dict_new, ignore_index=True)
print(df)
NOTE: As long as the keys in your created dictionary are the same, appending it to an existing dataframe shouldn't be cumbersome. Source