Srimulat

Whatsapp group chat analyzer using python & postgres

Installation

• Export whatsapp history
• Summon srimulat

$ python srimulat.py [WhatsAppBackupFile.txt]

• Srimulat will give you file called "srimulat.sql"
• Deploy those sql into your postgres
• Start playing with some sql inside ./sql directories
• Have Fun !

Feature

• Get member and total post
• Age of group
• Post time frequency (midnight, morning, afternoon, evening, night)
• Count word frequency
• Count Some word frequency
• Word frequency by specific member
• Total Post Group By Member, Month, Year
• Show Busiest month
• Most used words by some member in the morning
• Member who summon "someone" frequently
• Top 10 Busiest Days
• Show discussion within busiest days

Educational Purposes

Gen Z student raised with social media culture. They use whatsapp, telegram, line, etc to interact with their friends, family, etc. Such tools are very close to their lifes. By using any of it as an example, teacher can attract student into programming / rdbms concept more easily. Some interesting problem to solve :

Beginner/Intermediate topic:

• Analyze friends personality based on posted contents (Aggregation)
• Normalize chat history tables (Normalization concept)
• Convert some srimulat feature using normal table (Intro to crud / join concept)
• Transform query result into graphical diagram (Descriptive statistics)
• Found most active / most silent friends (Aggregation)
• Find friends idle / busy day by aggregating their post (Aggregation)

Advance topic :

• Creating a word stemmer within posted content
• Performance Tuning

Long Live Srimulat

Top LeftToRight : Paul - Subur - Basuki - Pak Bendot - Nurbuat - Darsono - Tarzan 
Bottom LeftToRight : Gepeng - Timbul - Sigit - Triman

License

Srimulat are Teguh slamet rahardjo and Raden Ayu Srimulat trademark.
https://id.wikipedia.org/wiki/Srimulat

Licensed under the Apache License, Version 2.0 (the "License")