Stuck on Thread Shed. Your input will be appreciated!

KINDLY HELP: customers, sales and thread_sold print outputs are not in line with the expected output

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!

#1. Break up `daily_sales` in easy to understand lists `customers`, `sales`, and `threads_sold

daily_sales_replaced = daily_sales.replace(";,;", ";")

daily_transactions = daily_sales_replaced.split(",")

#print(daily_transactions)

daily_transactions_split = []

for data in daily_transactions:

  daily_transactions_split.append(data.split(";"))

#print(daily_transactions_split)

transactions_clean = []

for clean in daily_transactions_split:

  transactions_clean = []

  for element in clean:

    #transactions_clean.append(element.strip("\n").strip())

     transactions_clean += [(element.strip("\n").strip())] 

   # transactions_clean.append(element.replace("\n", "").strip())

print(transactions_clean)

customers = []#

sales = []

thread_sold = []

for seperate in transactions_clean:  

  customers.append(seperate[0])

  sales.append(seperate[1])

  thread_sold.append(seperate[2])

print(customers)

print(sales)

print(thread_sold)

#Determine the total value of the days sales.

total_sales = 0

for sale in sales:

  remove_sign = sale.strip("$")

  total_sales += float(remove_sign)

PRINT OUTPUTS
[‘Myrtle Morris’, ‘$22.66’, ‘green&white&blue’, ‘09/15/17’] #print(transactions_clean)

[‘M’, ‘$’, ‘g’, ‘0’] #print(customers)

[‘y’, ‘2’, ‘r’, ‘9’] #print(sales)

[‘r’, ‘2’, ‘e’, ‘/’] #print(thread_sold)

Traceback (most recent call last):
File “script.py”, line 146, in
total_sales += float(remove_sign)
ValueError: could not convert string to float: ‘y’

Couple of things. First, it’s very difficult for anyone to help when your code is basically unreadable. Please review How do I format code in my posts?

Working with a large set of data as we have in the very long string daily_sales makes debugging difficult. Try commenting out all but the first 2 or 3 transactions. Then you can add print() statements before and after each operation, and see what is going in and what is coming out. If one or both is not what’s expected, you can follow your code to where the problem starts.

1 Like

Will really appreciate

Code

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!

  #1. Break up  `daily_sales`  in easy to understand lists  `customers` ,  `sales` , and `threads_sold

   daily_sales_replaced = daily_sales.replace(";,;", “;”)

   daily_transactions = daily_sales_replaced.split(",")

  #print(daily_transactions)

  daily_transactions_split = 

 for data in daily_transactions:

 daily_transactions_split.append(data.split(";"))

 #print(daily_transactions_split)

 transactions_clean = 

 for clean in daily_transactions_split:

 transactions_clean = 

for element in clean:
    #transactions_clean.append(element.strip("\n").strip())

    transactions_clean += [(element.strip("\n").strip())] 

transactions_clean.append(element.replace("\n", “”).strip())

 print(transactions_clean)

 customers = #

sales = 

thread_sold = 

for seperate in transactions_clean:

customers.append(seperate[0])

sales.append(seperate[1])

thread_sold.append(seperate[2])

 print(customers)

 print(sales)

 print(thread_sold)

 #Determine the total value of the days sales.

   total_sales = 0

   for sale in sales:

   remove_sign = sale.strip("$")

  total_sales += float(remove_sign)

    PRINT OUTPUTS
    [‘Myrtle Morris’, ‘$22.66’, ‘green&white&blue’, ‘09/15/17’] #print(transactions_clean)

   [‘M’, ‘$’, ‘g’, ‘0’] #print(customers)

   [‘y’, ‘2’, ‘r’, ‘9’] #print(sales)

  [‘r’, ‘2’, ‘e’, ‘/’] #print(thread_sold)

 Traceback (most recent call last):
 File “script.py”, line 146, in
 total_sales += float(remove_sign)
 ValueError: could not convert string to float: ‘y’

I can see you attempted to format your code by adding the back ticks, but it looks like you added them in several places. You just need three on an otherwise empty line before your code, and three more on the line after your code:

    ```
    #code goes here
    ```

I’m going to work some moderator vudu, and fix your originally posted code. I’m also going to edit your last post, so it’s less in the way.

Now if you comment out the original daily_sales, and use something shorter like the following in its place:

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"""

you can add some print() statements to your code.

If you look at these results:

It seems evident that transactions_clean is missing all of the data except the last transaction. I would go to where you assigned (appended) values to transaction_clean, and print the values before and after to observe what is happening. For example:

transactions_clean = []
print('daily_transactions_split: ', daily_transactions_split) #debug print
for clean in daily_transactions_split:
  print('clean: ', clean) #debug print
  print('transactions_clean: ', transactions_clean) #debug print
  transactions_clean = []

  for element in clean:
    print('element: ', element) #debug print
    #transactions_clean.append(element.strip("\n").strip())

     transactions_clean += [(element.strip("\n").strip())] #this line is over indented by a space
    print('transactions_clean after += operation: ', transactions_clean) #debug print
   # transactions_clean.append(element.replace("\n", "").strip())

print(transactions_clean) #does this show all three transactions?

If everything is working properly, we should expect to see data from all three of the transactions from the shortened daily_sales variable.

What you are trying to achieve for this project is a list of lists. The inner lists each represent a single transaction. For the smaller data sample used in my examples the final value of transactions_clean should look like this:

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

Thank you! I saw my mistake. Resolved

1 Like