Data Modeling Assignment

Question

We want you to create a data model of all events which you feel need to be captured on these 2 url's with Event name, data type and attributes.

●           Indigo Search - https://www.goindigo.in/

●           Myntra Checkout - https://www.myntra.com/checkout/cart

You can use a google spreadsheet to create the data model.

Answer 1

# TODO capture data from indigo and myntra

cols = ["Platform", "Flow", "Event Name", "Event Description", "Attribute Name", "Type", "Required", "Attribute Description"," Example Value", "PII/Sensitive"]

df_indigo = pd.DataFrame(rows_indigo, columns=cols)

df_myntra = pd.DataFrame(rows_myntra, columns=cols)

out_path = Path("/mnt/data/event_data_model.xlsx")

with pd.ExcelWriter(out_path, engine="xlsxwriter") as writer:

df_indigo.to_excel(writer, sheet_name="Indigo Search Events", index=False)

df_myntra.to_excel(writer, sheet_name="Myntra Checkout Events", index=False)