pd_df.py

import pandas as pd
col_dict = {'title':titles, 'price':prices, 'rating':ratings}
book_store = pd.DataFrame(col_dict)

print(book_store.head())
print(book_store.dtypes)

book_store['price'] = book_store['price'].apply(lambda x : float(x[2:]))

number_mapping = {'One':1,'Two':2,'Three':3,'Four':4,'Five':5}
book_store['rating'] = book_store['rating'].apply(lambda x : number_mapping.get(x))

print(book_store.head())
print(book_store.dtypes)

book_store.to_csv('book_store.csv')