I was wondering if step 8 is correct because I’m thinking that the name price color should be a together in a list and not separated.
daily_sales_replaced = daily_sales.replace(';,;',';')
daily_transactions = daily_sales_replaced.split(',')
daily_transactions_split = []
for trans in daily_transactions:
daily_transactions_split.append(trans.split(';'))
transactions_clean = []
for row in daily_transactions_split:
for column in row:
transactions_clean.append(column.split())
print (transactions_clean)