Organize Whatsapp raw data into a table

Version 1.0.1 (2,71 ko) par Eugenio Bertolini
After copying your Whatsapp chat on excel, load the excel file on Matlab and organize it into this table: 'message', 'sender', 'timestamp'.
0.0
(0)
26 téléchargements
Mise à jour 22 jan. 2021

Afficher la licence

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
||

Citation pour cette source

Eugenio Bertolini (2024). Organize Whatsapp raw data into a table (https://www.mathworks.com/matlabcentral/fileexchange/86163-organize-whatsapp-raw-data-into-a-table), MATLAB Central File Exchange. Récupéré le .

Compatibilité avec les versions de MATLAB
Créé avec R2020b
Compatible avec toutes les versions
Plateformes compatibles
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!

Version Publié le Notes de version
1.0.1

Tags and image added
1.0.0