import csv

f = open("icecream-new.csv", "r")
data = list(csv.reader(f))
f.close()

for row in data:
    print(row)
    
###

import json

f2 = open("icecream.json", "r")
obj = json.load(f2)
f2.close()

print(obj)

###

f3 = open("chat.txt", "r")
text = f3.read()
f3.close()

lines = text.split("\n")

names = []
for line in lines:
    start = line.index("From  ") + len("From  ")
    line = line[start:]
    end = line.index(" : ")
    line = line[:end]
    if "(Privately)" in line:
        newEnd = line.index(" to ")
        line = line[:newEnd]
    line = line.strip()
    names.append(line)
print(names)

###

f = open("icecream-new.csv", "r")
data = list(csv.reader(f))
f.close()

# make everything lowercase x
# remove timestamps
# add chocolate number

for row in range(len(data)):
    data[row].pop(0)
    chocCount = 0
    for col in range(len(data[row])):
        data[row][col] = data[row][col].lower()
        if "choc" in data[row][col]:
            chocCount += 1
    data[row].append(chocCount)
    print(data[row])
