image thumbnail

Organize Whatsapp raw data into a table

version 1.0.1 (2.71 KB) by Eugenio Bertolini
After copying your Whatsapp chat on excel, load the excel file on Matlab and organize it into this table: 'message', 'sender', 'timestamp'.


Updated 22 Jan 2021

View License

To perform sentiment analysis on Whatsapp data, it's necessary to structure them, separating the text's strings from the sender and the sending time. You can just copy-paste your chat on excel, then remove the rows that don't respect the classic formatting (that is as shown in this example: "[12:46, 10/7/2020] Eugenio Bertolini: Thank you"), leaving them as missing values. After, use this function to import and reorganize the information contained in the Whatsapp raw data, as shown below:

'row_data' || 'sentence' 'person' 'timestamp'
"[12:46, 10/7/2020] Eugenio Bertolini: Thank you" --> "Thank you" | "Eugenio Bertolini" | 738069.543056

Cite As

Eugenio Bertolini (2022). Organize Whatsapp raw data into a table (, MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2020b
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!