Organize Whatsapp raw data into a table

After copying your Whatsapp chat on excel, load the excel file on Matlab and organize it into this table: 'message', 'sender', 'timestamp'.

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