Thread Shed

Hello!
Read through all resolutions, Step 19 getting same result 0
Rewrote everything, print each step…
Copy paced the previous examples, and the unstuck result, nothing help
Please help to resolve:

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

Or this is my second option, that gives NONE:

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

Lines 153-158

color_count = 0
def color_count(color):
  if color == thread_sold_split:
    color_count += 1
    return color_count
print(color_count('white'))

Note that we cannot mutate a global variable from inside a function. We can either,

  • define the variable inside the function (preferred)
  • declare a global binding to the variable
    global color_count

Only problem with that is we have to reset the value to zero every time we call the function.

Also note that we should not be calling a function before the definition is given. This is referring to your first example.

Tracing back to the thread_sold_split object, are we expecting a list of lists?

[['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']]
1 Like

Additionally…
Does this:

transactions_clean = []  
for transaction in daily_transactions_split:
  transaction_clean = []
  for data in transaction:
   transaction_clean.append(data.replace("\n", '').strip(' '))
   transactions_clean.append(transaction_clean)
print(transactions_clean)

produce the correct results? Check your indentation on that second for loop. That might fix the errors that follow to a degree.

Why are you using the index of 1 here?
total_sales += float(sale[1].strip('$'))

Would this make more sense?
total_sales += round(float(sale.strip('$')))

1 Like

Hello, still getting 112 ;(
Rewrote everything…
Cant find the problem

This line is what I was referring to (also if you search here in the forums as it’s a common issue, as the help video isn’t too clear [we’ve brought this up w/CC over the years and it’s not fixed :woman_shrugging: ]).

What happens when you unindent transactions_clean.append(transaction_clean)?

Hint:

Summary

transactions_clean.append(transaction_clean) has to be at the outside level of the inner for loop, otherwise, you’re cleaning, appending, and appending again which gives you dupes.

Oh, wow!!!
@lisalisaj it works after unindent!!!
Thank You!

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