I think I figured out how to sort this out, this is the problem code. You were right I had to go and write up the code all again to find the smallest problem.
Thank you midlindner
daily_sales_replaced = daily_sales.replace(';,;', ',')
daily_transactions = daily_sales_replaced.split(",")
#print(daily_transactions)
daily_transactions_split = []
for transaction in daily_transactions:
daily_transactions_split.append(transaction.split(';'))
transactions_clean = []
for transaction in daily_transactions_split:
transaction_clean=[]
for data_point in transaction:
transaction_clean.append(data_point.replace("\n", " ").strip(""))
transactions_clean.append(transaction_clean)
print(transactions_clean)
customers = []
sales = []
thread_sold = []
and this is after the fix:
daily_sales_replaced = daily_sales.replace(';,;', ' ; ')
daily_transactions = daily_sales_replaced.split(",")
#print(daily_transactions)
daily_transactions_split = []
for transaction in daily_transactions:
daily_transactions_split.append(transaction.split(';'))
#print(daily_transactions_split)
transactions_clean = []
for transaction in daily_transactions_split:
transaction_clean=[]
for data_point in transaction:
transaction_clean.append(data_point.replace("\n", " ").strip(" "))
transactions_clean.append(transaction_clean)
print(transactions_clean)
customers = []
sales = []
thread_sold = []