import csv

f = open("icecream.csv", "r")
reader = csv.reader(f)

data = list(reader)
print(data)

f.close()

###

import json

f = open("icecream.json", "r")
j = json.load(f)

print(j)

f.close()

###

f = open("chat.txt", "r")
text = f.read()
lines = text.split("\n")
names = [ ]
for line in lines:
    startText = "From  "
    endText = " : "
    startIndex = line.index(startText)
    result = line[startIndex+len(startText):]
    endIndex = result.index(endText)
    result = result[:endIndex]
    if "  to  " in result:
        endIndex = result.index("  to  ")
        result = result[:endIndex]
    names.append(result)
print(names)

###

f2 = open("icecream.csv", "r")
data = list(csv.reader(f2))
f2.close()

data[0].pop(0)
data[0].append("Choc Count")
for row in range(1, len(data)):
    data[row].pop(0)
    chocCount = 0
    for col in range(len(data[row])):
        data[row][col] = data[row][col].lower()
        if "choco" in data[row][col]:
            chocCount += 1
    data[row].append(chocCount)

print(data)