Organize Whatsapp raw data into a table

Versione 1.0.1 (2,71 KB) da 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 download
Aggiornato 22 gen 2021

Visualizza la licenza

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

Cita come

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

Compatibilità della release di MATLAB
Creato con R2020b
Compatibile con qualsiasi release
Compatibilità della piattaforma
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!

Versione Pubblicato Note della release
1.0.1

Tags and image added
1.0.0