dict to dataframe

main.py

# transform data from dict to dataframe
import pandas as pd
from tqdm import tqdm

data = pd.DataFrame(columns=['category', 'name'])

for category in tqdm(all_categories):
    names = category_lines[category]
    for name in names:
        frame = {'category':category, 'name':name}
        data = data.append(frame, ignore_index=True)
data