Thread Shed

Data Science
1

Hey guys I dont know why but I keep on getting a index error even though my lists are in all range. I was wondering if anyone could help me at on where im going wrong, would really appreciate it. Thanks!

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 """ #------------------------------------------------ # Start coding below! #name price color 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 data_point in transactions_clean: customers.append(data_point[0]) sales.append(data_point[1]) thread_sold.append(data_point[2]) print(customers) print(sales) print(thread_sold)
2 
customers = []
sales = []
thread_sold = []

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

replace the word, “data_point” with “item” and see what happens.

1 Like
3

will do thanks for the reply!

4

its still out of range according to the terminal, im really confused as to why its out of range even though its exactly how the solution is

5

But, it’s not how the solution looks. Sometimes it’s helpful to break up the code blocks into smaller pieces—rather than have a wall of code which is hard to sift through–so you can determine where exactly the error is. (which is what I just did in a code editor).

Okay, this line:

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

where is the pipe “|” coming from?

That symbol shouldn’t be in the code. What’s currently there and what should be replaced?
Should be:
daily_sales_replaced = daily_sales.replace(';,;', '+')

This line:
daily_transactions_split.append(transaction.split(";,;"))

Should be:

daily_transactions_split.append(transaction.split('+'))
>>[['Edith Mcbride   ', '$1.21   ', '   white ', '\n09/15/17   '], ['Herbert Tran   ', '   $7.29', '\nwhite&blue', '   09/15/17 '], ['Pa...e

The way you have this section of code:

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)

#produces this, which is incorrect...b/c it's not a list of lists.

>>>>[['Edith Mcbride   |$1.21   |   white |09/15/17'], ['Herbert Tran   |   $7.29|white&

Which is why the last bit of code throws that error, "list index out of range:

customers = []
sales = []
thread_sold = []

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

There is no index 1 or 2, b/c there’s only one item at index 0 in your output. (which is what 'list index out of range" error means, you’re attempting to access an element at an index that doesn’t exist).

It’s supposed to produce a list of lists, like this:

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)

>>[['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'], [...
2 Likes
6

oh I see. thank you so much!