Thread shed-Why does the list keep doubling itself cant find the bug

text7379741238 · June 5, 2023, 6:51am

# Start coding below!
daily_sales_replaced = daily_sales.replace(";,;","+ ")
#print(daily_sales_replaced)
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 = []

for transaction in transactions_clean:
  customers.append(transaction[0])
  sales .append(transaction[1])
  thread_sold.append(transaction[2])
print(customers)
print(sales)
print(thread_sold)

text7379741238 · June 5, 2023, 6:52am

output:

['Edith Mcbride', 'Edith Mcbride', 'Edith Mcbride', 'Edith Mcbride', 'Herbert Tran', 'Herbert Tran', 'Herbert Tran', 'Herbert Tran', 'Paul Clarke', 'Paul Clarke', 'Paul Clarke', 'Paul Clarke', 'Lucille Caldwell', 'Lucille Caldwell', 'Lucille Caldwell', 'Lucille Caldwell', 'Eduardo George', 'Eduardo George', 'Eduardo George', 'Eduardo George', 'Danny Mclaughlin', 'Danny Mclaughlin', 'Danny Mclaughlin', 'Danny Mclaughlin', 'Stacy Vargas', 'Stacy Vargas', 'Stacy Vargas', 'Stacy Vargas', 'Shaun Brock', 'Shaun Brock', 'Shaun Brock', 'Shaun Brock', 'Erick Harper', 'Erick Harper', 'Erick Harper', 'Erick Harper', 'Michelle Howell', 'Michelle Howell', 'Michelle Howell', 'Michelle Howell', 'Carroll Boyd', 'Carroll Boyd', 'Carroll Boyd', 'Carroll Boyd', 'Teresa Carter', 'Teresa Carter', 'Teresa Carter', 'Teresa Carter', 'Jacob Kennedy', 'Jacob Kennedy', 'Jacob Kennedy', 'Jacob Kennedy', 'Craig Chambers', 'Craig Chambers', 'Craig Chambers', 'Craig Chambers', 'Peggy Bell', 'Peggy Bell', 'Peggy Bell', 'Peggy Bell', 'Kenneth Cunningham', 'Kenneth Cunningham', 'Kenneth Cunningham', 'Kenneth Cunningham', 'Marvin Morgan', 'Marvin Morgan', 'Marvin Morgan', 'Marvin Morgan', 'Marjorie Russell', 'Marjorie Russell', 'Marjorie Russell', 'Marjorie Russell', 'Israel Cummings', 'Israel Cummings', 'Israel Cummings', 'Israel Cummings', 'June Doyle', 'June Doyle', 'June Doyle', 'June Doyle', 'Jaime Buchanan', 'Jaime Buchanan', 'Jaime Buchanan', 'Jaime Buchanan', 'Rhonda Farmer', 'Rhonda Farmer', 'Rhonda Farmer', 'Rhonda Farmer', 'Darren Mckenzie', 'Darren Mckenzie', 'Darren Mckenzie', 'Darren Mckenzie', 'Rufus Malone', 'Rufus Malone', 'Rufus Malone', 'Rufus Malone', 'Hubert Miles', 'Hubert Miles', 'Hubert Miles', 'Hubert Miles', 'Joseph Bridges', 'Joseph Bridges', 'Joseph Bridges', 'Joseph Bridges', 'Sergio Murphy', 'Sergio Murphy', 'Sergio Murphy', 'Sergio Murphy', 'Audrey Ferguson', 'Audrey Ferguson', 'Audrey Ferguson', 'Audrey Ferguson', 'Edna Williams', 'Edna Williams', 'Edna Williams', 'Edna Williams', 'Randy Fleming', 'Randy Fleming', 'Randy Fleming', 'Randy Fleming', 'Elisa Hart', 'Elisa Hart', 'Elisa Hart', 'Elisa Hart', 'Ernesto Hunt', 'Ernesto Hunt', 'Ernesto Hunt', 'Ernesto Hunt', 'Shannon Chavez', 'Shannon Chavez', 'Shannon Chavez', 'Shannon Chavez', 'Sammy Cain', 'Sammy Cain', 'Sammy Cain', 'Sammy Cain', 'Steven Reeves', 'Steven Reeves', 'Steven Reeves', 'Steven Reeves', 'Ruben Jones', 'Ruben Jones', 'Ruben Jones', 'Ruben Jones', 'Essie Hansen', 'Essie Hansen', 'Essie Hansen', 'Essie Hansen', 'Rene Hardy', 'Rene Hardy', 'Rene Hardy', 'Rene Hardy', 'Lucy Snyder', 'Lucy Snyder', 'Lucy Snyder', 'Lucy Snyder', 'Dallas Obrien', 'Dallas Obrien', 'Dallas Obrien', 'Dallas Obrien', 'Stacey Payne', 'Stacey Payne', 'Stacey Payne', 'Stacey Payne', 'Tanya Cox', 'Tanya Cox', 'Tanya Cox', 'Tanya Cox', 'Melody Moran', 'Melody Moran', 'Melody Moran', 'Melody Moran', 'Louise Becker', 'Louise Becker', 'Louise Becker', 'Louise Becker', 'Ryan Webster', 'Ryan Webster', 'Ryan Webster', 'Ryan Webster', 'Justin Blake', 'Justin Blake', 'Justin Blake', 'Justin Blake', 'Beverly Baldwin', 'Beverly Baldwin', 'Beverly Baldwin', 'Beverly Baldwin', 'Dale Brady', 'Dale Brady', 'Dale Brady', 'Dale Brady', 'Guadalupe Potter', 'Guadalupe Potter', 'Guadalupe Potter', 'Guadalupe Potter', 'Desiree Butler', 'Desiree Butler', 'Desiree Butler', 'Desiree Butler', 'Sonja Barnett', 'Sonja Barnett', 'Sonja Barnett', 'Sonja Barnett', 'Angelica Garza', 'Angelica Garza', 'Angelica Garza', 'Angelica Garza', 'Jamie Welch', 'Jamie Welch', 'Jamie Welch', 'Jamie Welch', 'Rex Hudson', 'Rex Hudson', 'Rex Hudson', 'Rex Hudson', 'Nadine Gibbs', 'Nadine Gibbs', 'Nadine Gibbs', 'Nadine Gibbs', 'Hannah Pratt', 'Hannah Pratt', 'Hannah Pratt', 'Hannah Pratt', 'Gayle Richards', 'Gayle Richards', 'Gayle Richards', 'Gayle Richards', 'Stanley Holland', 'Stanley Holland', 'Stanley Holland', 'Stanley Holland', 'Anna Dean', 'Anna Dean', 'Anna Dean', 'Anna Dean', 'Terrance Saunders', 'Terrance Saunders', 'Terrance Saunders', 'Terrance Saunders', 'Brandi Zimmerman', 'Brandi Zimmerman', 'Brandi Zimmerman', 'Brandi Zimmerman', 'Guadalupe Freeman', 'Guadalupe Freeman', 'Guadalupe Freeman', 'Guadalupe Freeman', 'Irving Patterson', 'Irving Patterson', 'Irving Patterson', 'Irving Patterson', 'Karl Ross', 'Karl Ross', 'Karl Ross', 'Karl Ross', 'Brandy Cortez', 'Brandy Cortez', 'Brandy Cortez', 'Brandy Cortez', 'Mamie Riley', 'Mamie Riley', 'Mamie Riley', 'Mamie Riley', 'Mike Thornton', 'Mike Thornton', 'Mike Thornton', 'Mike Thornton', 'Jamie Vaughn', 'Jamie Vaughn', 'Jamie Vaughn', 'Jamie Vaughn', 'Noah Day', 'Noah Day', 'Noah Day', 'Noah Day', 'Josephine Keller', 'Josephine Keller', 'Josephine Keller', 'Josephine Keller', 'Tracey Wolfe', 'Tracey Wolfe', 'Tracey Wolfe', 'Tracey Wolfe', 'Ignacio Parks', 'Ignacio Parks', 'Ignacio Parks', 'Ignacio Parks', 'Beatrice Newman', 'Beatrice Newman', 'Beatrice Newman', 'Beatrice Newman', 'Andre Norris', 'Andre Norris', 'Andre Norris', 'Andre Norris', 'Albert Lewis', 'Albert Lewis', 'Albert Lewis', 'Albert Lewis', 'Javier Bailey', 'Javier Bailey', 'Javier Bailey', 'Javier Bailey', 'Everett Lyons', 'Everett Lyons', 'Everett Lyons', 'Everett Lyons', 'Abraham Maxwell', 'Abraham Maxwell', 'Abraham Maxwell', 'Abraham Maxwell', 'Traci Craig', 'Traci Craig', 'Traci Craig', 'Traci Craig', 'Jeffrey Jenkins', 'Jeffrey Jenkins', 'Jeffrey Jenkins', 'Jeffrey Jenkins', 'Merle Wilson', 'Merle Wilson', 'Merle Wilson', 'Merle Wilson', 'Janis Franklin', 'Janis Franklin', 'Janis Franklin', 'Janis Franklin', 'Leonard Guerrero', 'Leonard Guerrero', 'Leonard Guerrero', 'Leonard Guerrero', 'Lana Sanchez', 'Lana Sanchez', 'Lana Sanchez', 'Lana Sanchez', 'Donna Ball', 'Donna Ball', 'Donna Ball', 'Donna Ball', 'Terrell Barber', 'Terrell Barber', 'Terrell Barber', 'Terrell Barber', 'Jody Flores', 'Jody Flores', 'Jody Flores', 'Jody Flores', 'Daryl Herrera', 'Daryl Herrera', 'Daryl Herrera', 'Daryl Herrera', 'Miguel Mcguire', 'Miguel Mcguire', 'Miguel Mcguire', 'Miguel Mcguire', 'Rogelio Gonzalez', 'Rogelio Gonzalez', 'Rogelio Gonzalez', 'Rogelio Gonzalez', 'Lora Hammond', 'Lora Hammond', 'Lora Hammond', 'Lora Hammond', 'Owen Ward', 'Owen Ward', 'Owen Ward', 'Owen Ward', 'Malcolm Morales', 'Malcolm Morales', 'Malcolm Morales', 'Malcolm Morales', 'Eric Mcdaniel', 'Eric Mcdaniel', 'Eric Mcdaniel', 'Eric Mcdaniel', 'Madeline Estrada', 'Madeline Estrada', 'Madeline Estrada', 'Madeline Estrada', 'Leticia Manning', 'Leticia Manning', 'Leticia Manning', 'Leticia Manning', 'Mario Wallace', 'Mario Wallace', 'Mario Wallace', 'Mario Wallace', 'Lewis Glover', 'Lewis Glover', 'Lewis Glover', 'Lewis Glover', 'Gail Phelps', 'Gail Phelps', 'Gail Phelps', 'Gail Phelps', 'Myrtle Morris', 'Myrtle Morris', 'Myrtle Morris', 'Myrtle Morris']
['$1.21', '$1.21', '$1.21', '$1.21', '$7.29', '$7.29', '$7.29', '$7.29', '$12.52', '$12.52', '$12.52', '$12.52', '$5.13', '$5.13', '$5.13', '$5.13', '$20.39', '$20.39', '$20.39', '$20.39', '$30.82', '$30.82', '$30.82', '$30.82', '$1.85', '$1.85', '$1.85', '$1.85', '$17.98', '$17.98', '$17.98', '$17.98', '$17.41', '$17.41', '$17.41', '$17.41', '$28.59', '$28.59', '$28.59', '$28.59', '$14.51', '$14.51', '$14.51', '$14.51', '$19.64', '$19.64', '$19.64', '$19.64', '$11.40', '$11.40', '$11.40', '$11.40', '$8.79', '$8.79', '$8.79', '$8.79', '$8.65', '$8.65', '$8.65', '$8.65', '$10.53', '$10.53', '$10.53', '$10.53', '$16.49', '$16.49', '$16.49', '$16.49', '$6.55', '$6.55', '$6.55', '$6.55', '$11.86', '$11.86', '$11.86', '$11.86', '$22.29', '$22.29', '$22.29', '$22.29', '$8.35', '$8.35', '$8.35', '$8.35', '$2.91', '$2.91', '$2.91', '$2.91', '$22.94', '$22.94', '$22.94', '$22.94', '$4.70', '$4.70', '$4.70', '$4.70', '$3.59', '$3.59', '$3.59', '$3.59', '$5.66', '$5.66', '$5.66', '$5.66', '$17.51', '$17.51', '$17.51', '$17.51', '$5.54', '$5.54', '$5.54', '$5.54', '$17.13', '$17.13', '$17.13', '$17.13', '$21.13', '$21.13', '$21.13', '$21.13', '$0.35', '$0.35', '$0.35', '$0.35', '$13.91', '$13.91', '$13.91', '$13.91', '$19.26', '$19.26', '$19.26', '$19.26', '$5.45', '$5.45', '$5.45', '$5.45', '$5.50', '$5.50', '$5.50', '$5.50', '$14.56', '$14.56', '$14.56', '$14.56', '$7.33', '$7.33', '$7.33', '$7.33', '$20.22', '$20.22', '$20.22', '$20.22', '$8.67', '$8.67', '$8.67', '$8.67', '$8.31', '$8.31', '$8.31', '$8.31', '$15.70', '$15.70', '$15.70', '$15.70', '$6.74', '$6.74', '$6.74', '$6.74', '$30.84', '$30.84', '$30.84', '$30.84', '$12.31', '$12.31', '$12.31', '$12.31', '$2.94', '$2.94', '$2.94', '$2.94', '$22.46', '$22.46', '$22.46', '$22.46', '$6.60', '$6.60', '$6.60', '$6.60', '$6.27', '$6.27', '$6.27', '$6.27', '$21.12', '$21.12', '$21.12', '$21.12', '$2.10', '$2.10', '$2.10', '$2.10', '$14.22', '$14.22', '$14.22', '$14.22', '$11.60', '$11.60', '$11.60', '$11.60', '$25.27', '$25.27', '$25.27', '$25.27', '$8.26', '$8.26', '$8.26', '$8.26', '$30.80', '$30.80', '$30.80', '$30.80', '$22.61', '$22.61', '$22.61', '$22.61', '$22.19', '$22.19', '$22.19', '$22.19', '$7.47', '$7.47', '$7.47', '$7.47', '$5.49', '$5.49', '$5.49', '$5.49', '$23.70', '$23.70', '$23.70', '$23.70', '$26.66', '$26.66', '$26.66', '$26.66', '$25.95', '$25.95', '$25.95', '$25.95', '$19.55', '$19.55', '$19.55', '$19.55', '$15.68', '$15.68', '$15.68', '$15.68', '$23.57', '$23.57', '$23.57', '$23.57', '$29.32', '$29.32', '$29.32', '$29.32', '$26.44', '$26.44', '$26.44', '$26.44', '$17.24', '$17.24', '$17.24', '$17.24', '$8.49', '$8.49', '$8.49', '$8.49', '$13.10', '$13.10', '$13.10', '$13.10', '$20.39', '$20.39', '$20.39', '$20.39', '$14.70', '$14.70', '$14.70', '$14.70', '$22.45', '$22.45', '$22.45', '$22.45', '$28.46', '$28.46', '$28.46', '$28.46', '$23.89', '$23.89', '$23.89', '$23.89', '$24.49', '$24.49', '$24.49', '$24.49', '$1.81', '$1.81', '$1.81', '$1.81', '$6.81', '$6.81', '$6.81', '$6.81', '$0.65', '$0.65', '$0.65', '$0.65', '$26.45', '$26.45', '$26.45', '$26.45', '$7.69', '$7.69', '$7.69', '$7.69', '$8.74', '$8.74', '$8.74', '$8.74', '$1.86', '$1.86', '$1.86', '$1.86', '$14.75', '$14.75', '$14.75', '$14.75', '$28.10', '$28.10', '$28.10', '$28.10', '$9.91', '$9.91', '$9.91', '$9.91', '$16.34', '$16.34', '$16.34', '$16.34', '$27.57', '$27.57', '$27.57', '$27.57', '$5.25', '$5.25', '$5.25', '$5.25', '$9.51', '$9.51', '$9.51', '$9.51', '$20.56', '$20.56', '$20.56', '$20.56', '$21.64', '$21.64', '$21.64', '$21.64', '$24.99', '$24.99', '$24.99', '$24.99', '$29.70', '$29.70', '$29.70', '$29.70', '$15.52', '$15.52', '$15.52', '$15.52', '$15.70', '$15.70', '$15.70', '$15.70', '$12.36', '$12.36', '$12.36', '$12.36', '$13.66', '$13.66', '$13.66', '$13.66', '$30.52', '$30.52', '$30.52', '$30.52', '$22.66', '$22.66', '$22.66', '$22.66']
['white', 'white', 'white', 'white', 'white&blue', 'white&blue', 'white&blue', 'white&blue', 'white&blue', 'white&blue', 'white&blue', 'white&blue', 'white', 'white', 'white', 'white', 'white&yellow', 'white&yellow', 'white&yellow', 'white&yellow', 'purple', 'purple', 'purple', 'purple', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'blue', 'blue', 'blue', 'blue', 'blue', 'blue', 'blue', 'blue', 'purple&blue', 'purple&blue', 'purple&blue', 'purple&blue', 'white', 'white', 'white', 'white', 'white&red', 'white&red', 'white&red', 'white&red', 'white&blue&red', 'white&blue&red', 'white&blue&red', 'white&blue&red', 'blue', 'blue', 'blue', 'blue', 'green&blue', 'green&blue', 'green&blue', 'green&blue', 'green&blue&red', 'green&blue&red', 'green&blue&red', 'green&blue&red', 'green&blue&red', 'green&blue&red', 'green&blue&red', 'green&blue&red', 'black', 'black', 'black', 'black', 'black&yellow', 'black&yellow', 'black&yellow', 'black&yellow', 'white&black&yellow', 'white&black&yellow', 'white&black&yellow', 'white&black&yellow', 'white&black&yellow', 'white&black&yellow', 'white&black&yellow', 'white&black&yellow', 'green', 'green', 'green', 'green', 'green&yellow', 'green&yellow', 'green&yellow', 'green&yellow', 'green&yellow&blue', 'green&yellow&blue', 'green&yellow&blue', 'green&yellow&blue', 'green&yellow&purple&blue', 'green&yellow&purple&blue', 'green&yellow&purple&blue', 'green&yellow&purple&blue', 'black', 'black', 'black', 'black', 'black&blue', 'black&blue', 'black&blue', 'black&blue', 'black&blue', 'black&blue', 'black&blue', 'black&blue', 'black', 'black', 'black', 'black', 'black&purple', 'black&purple', 'black&purple', 'black&purple', 'black&purple', 'black&purple', 'black&purple', 'black&purple', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow&red', 'yellow&red', 'yellow&red', 'yellow&red', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow&blue', 'yellow&blue', 'yellow&blue', 'yellow&blue', 'yellow&blue&red', 'yellow&blue&red', 'yellow&blue&red', 'yellow&blue&red', 'black', 'black', 'black', 'black', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'white&black&red', 'white&black&red', 'white&black&red', 'white&black&red', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow&black', 'yellow&black', 'yellow&black', 'yellow&black', 'green&yellow&black', 'green&yellow&black', 'green&yellow&black', 'green&yellow&black', 'yellow', 'yellow', 'yellow', 'yellow', 'white&yellow', 'white&yellow', 'white&yellow', 'white&yellow', 'white&yellow&black', 'white&yellow&black', 'white&yellow&black', 'white&yellow&black', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow', 'white', 'white', 'white', 'white', 'white&black', 'white&black', 'white&black', 'white&black', 'white&black', 'white&black', 'white&black', 'white&black', 'white&black&red', 'white&black&red', 'white&black&red', 'white&black&red', 'purple', 'purple', 'purple', 'purple', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'purple&yellow', 'green&purple&yellow', 'green&purple&yellow', 'green&purple&yellow', 'green&purple&yellow', 'red', 'red', 'red', 'red', 'yellow&red', 'yellow&red', 'yellow&red', 'yellow&red', 'green&yellow&red', 'green&yellow&red', 'green&yellow&red', 'green&yellow&red', 'red', 'red', 'red', 'red', 'green&red', 'green&red', 'green&red', 'green&red', 'green&white&red', 'green&white&red', 'green&white&red', 'green&white&red', 'white', 'white', 'white', 'white', 'white&red', 'white&red', 'white&red', 'white&red', 'purple', 'purple', 'purple', 'purple', 'purple', 'purple', 'purple', 'purple', 'green', 'green', 'green', 'green', 'green', 'green', 'green', 'green', 'green', 'green', 'green', 'green', 'red', 'red', 'red', 'red', 'white&red', 'white&red', 'white&red', 'white&red', 'white&purple&red', 'white&purple&red', 'white&purple&red', 'white&purple&red', 'red', 'red', 'red', 'red', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'black&red', 'green', 'green', 'green', 'green', 'green&yellow', 'green&yellow', 'green&yellow', 'green&yellow', 'green&yellow&blue', 'green&yellow&blue', 'green&yellow&blue', 'green&yellow&blue', 'purple', 'purple', 'purple', 'purple', 'purple&black', 'purple&black', 'purple&black', 'purple&black', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow', 'yellow&blue', 'yellow&blue', 'yellow&blue', 'yellow&blue', 'green', 'green', 'green', 'green', 'green', 'green', 'green', 'green', 'white', 'white', 'white', 'white', 'white&blue', 'white&blue', 'white&blue', 'white&blue', 'white&black&blue', 'white&black&blue', 'white&black&blue', 'white&black&blue', 'green', 'green', 'green', 'green', 'green&yellow', 'green&yellow', 'green&yellow', 'green&yellow', 'green&yellow&black', 'green&yellow&black', 'green&yellow&black', 'green&yellow&black', 'green', 'green', 'green', 'green', 'green', 'green', 'green', 'green', 'green&purple', 'green&purple', 'green&purple', 'green&purple', 'green', 'green', 'green', 'green', 'green&white', 'green&white', 'green&white', 'green&white', 'green&white&blue', 'green&white&blue', 'green&white&blue', 'green&white&blue', 'green&white&blue', 'green&white&blue', 'green&white&blue', 'green&white&blue']

mtf · June 5, 2023, 7:30am

If you append two lists in the same iteration cycle, you get multiple records. Advise look at the loops the appends are contained in.