-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathhelper.py
68 lines (48 loc) · 2.08 KB
/
helper.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
from urlextract import URLExtract
from wordcloud import WordCloud
extract = URLExtract()
def fetch_stats(selected_user, df):
if selected_user != "Entire Chat":
filtered_df = df[df['user'] == selected_user]
if filtered_df.empty:
return 0, 0, 0, 0, None
else:
df = filtered_df
if 'date' not in df.columns:
return 0, 0, 0, 0, None
num_messages = df.shape[0]
words = []
for message in df['message']:
words.extend(message.split())
num_media_messages = df[df['message'] == '<Media omitted>\n'].shape[0]
links = []
for message in df['message']:
links.extend(extract.find_urls(message))
formatted_date = df['date'].dt.strftime("%m-%d-%Y").head(1).iloc[0]
return num_messages, len(words), num_media_messages, len(links), formatted_date
def most_active_user(df):
df = round((df['user'].value_counts()/df.shape[0])*100,2).reset_index().rename(columns={'index':'Name', 'user': 'Percent'})
return df
def create_wordcloud(selected_user, df):
if selected_user != "Entire Chat":
df = df[df['user'] == selected_user]
wc = WordCloud(width=500, height=500, min_font_size=10, background_color='white')
df_wc = wc.generate(df['message'].str.cat(sep=" "))
return df_wc
def monthly_timeline(selected_user, df):
if selected_user != "Entire Chat":
df = df[df['user'] == selected_user]
timeline = df.groupby(['year', 'month_num', 'month']).count()['message'].reset_index()
time = []
for i in range(timeline.shape[0]):
time.append(timeline['month'][i] + "-" + str(timeline['year'][i]))
timeline['time'] = time
return timeline
def week_activity_map(selected_user, df):
if selected_user != "Entire Chat":
df = df[df['user'] == selected_user]
return df['day_name'].value_counts()
def month_activity_map(selected_user, df):
if selected_user != "Entire Chat":
df = df[df['user'] == selected_user]
return df['month'].value_counts()