Gabriel Abiodun's Blog

Whatsapp group analysis

Whatsapp group analysis

Gabriel Abiodun's photo
Gabriel Abiodun
·

1 min read

Today, I decided to analyze my department whatsapp group chat

Tools :

  • Jupyter notebook
  • Microsoft Excel
  • Microsoft powerBi

Step 1 :The first time is to open any WhatsApp group chat you wish to analyze and do the following below

Screenshot_20220809_132139~3.jpg Click more and export chat

Screenshot_20220809_132153~3.jpg

Screenshot_20220809_132321~3.jpg

Screenshot_20220809_132400~3.jpg

Step 2 : open your Jupyter notebook and run the code from this GitHub link

Step 3 : import the csv file you generated from step 2 using Microsoft powerBi

Screenshot (202).png

Step 4 : Build charts with the csv file

I was able to create this

image_f1ed9dda-90db-40b9-8e76-a1b7cb72260420220813_200020.jpg

image_09810324-a26d-4143-a090-5e29fe3a493f20220813_200023.jpg

Step 5 : below are the calculated measures I did

Screenshot (214).png

Screenshot (219).png

Screenshot (217).png

Screenshot (207).png

Screenshot (218).png

Screenshot (211).png

Screenshot (205).png

whatsappChatShare