Whatever is done in excel you have to do it in python. Like you have to categorize the tweets related to app and other. It should be done by using pandas but i have already started using a text file.
#open, read line by line, split line into list of items, append list of items to a variable called data
f=open('./mandril.txt', encoding='utf-8',errors="replace")
data=[]
for line in f:
lower_line=line.lower()
#print(lower_line)
wlist=lower_line.split(' ')
data.append(wlist)
If you can extend it that would be great.
Attachment:- Assignment File.rar