Organize Whatsapp raw data into a table

版本 1.0.1 (2.7 KB) 作者: Eugenio Bertolini
After copying your Whatsapp chat on excel, load the excel file on Matlab and organize it into this table: 'message', 'sender', 'timestamp'.
26.0 次下载
更新时间 2021/1/22

查看许可证

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

引用格式

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. 检索来源 .

MATLAB 版本兼容性
创建方式 R2020b
兼容任何版本
平台兼容性
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!
版本 已发布 发行说明
1.0.1

Tags and image added

1.0.0