import csv

f = open("icecream.csv", "r")
reader = csv.reader(f)
print(type(reader))
data = list(reader)
print(data)
f.close()

###

import json

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

###

f = open("chat.txt", "r")
text = f.read()
f.close()
lines = text.split("\n")
for line in lines:
    startIndex = line.index("From") + 5
    line = line[startIndex:]
    endIndex = line.index(":") - 1
    line = line[:endIndex]
    if "(Privately)" in line:
        endIndex = line.index(" to ") - 1
        line = line[:endIndex]
    print(line.strip())

###

f = open("icecream.csv", "r")
reader = csv.reader(f)
data = list(reader)
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
    if row == 0:
        data[row].append("# Chocolate")
    else:
        data[row].append(chocCount)

print(data)
f.close()