# WhatsApp Group Chat Analysis (Influencer and dependents) **URL:** \ **Category:** KNIME Analytics Platform\ **Tags:** time-series\ **Created:** [June 6, 2023, 11:55am UTC](https://forum.knime.com/t/whatsapp-group-chat-analysis-influencer-and-dependents/68515 "2023-06-06T11:55:34Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![hakandurgut](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/h/c5a1d2/32.png) [@hakandurgut](https://forum.knime.com/u/hakandurgut)\ **Post date:** [June 6, 2023, 11:55am UTC](https://forum.knime.com/t/whatsapp-group-chat-analysis-influencer-and-dependents/68515/1 "2023-06-06T11:55:35Z")
Hi, I have exported a WhatsApp Group Chat, there are 7 participants in this WhatsApp group. Over a span of 218 days, a total of 7 individuals engaged in a lively conversation, resulting in a count of 3,719 chat messages exchanged. To begin, I would like to identify the individual conversations that took place, considering that there are several instances where conversations were separated by significant periods of waiting time. These conversations can be recognized as distinct exchanges that started and ended between specific individuals. During the span of 218 days, I noticed a pattern where certain individuals consistently responded to messages from specific people. In other words, there seemed to be a reliance on particular individuals to initiate conversations before others joined in. I must emphasize that this observation is based on my intuition and personal perception rather than scientific evidence. Nevertheless, I am eager to find a way to substantiate and provide evidence for this observation. the participant names are af ct eo hq ma oa sk [az chat export analysis.knwf](https://forum.knime.com/uploads/short-url/v2TSJdm7ljiUFwkaEeuzAZtwYxT.knwf) (220.2 KB) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/2/b/2b7ac8833b30674d67cc2f421126435e8bee9719.png) Could someone please assist me in solving this problem? I would greatly appreciate any help or guidance that can be provided. I would like to express my gratitude in advance to anyone who is willing to offer their assistance. Your support is greatly appreciated. ---
**Author:** ![AlexanderFillbrunn](https://forum-cdn.knime.com/user_avatar/forum.knime.com/alexanderfillbrunn/32/357_2.png) [@AlexanderFillbrunn](https://forum.knime.com/u/AlexanderFillbrunn)\ **Post date:** [June 6, 2023, 1:08pm UTC](https://forum.knime.com/t/whatsapp-group-chat-analysis-influencer-and-dependents/68515/2 "2023-06-06T13:08:46Z")
Hi, I see you already found the Lag Column, so it is rather easy. Quick note: you do not need the Lag Column for the Date&Time column, because the Date&Time Difference node has a “previous row” option. But you can lag the “Person” column and then filter by the Date&Time Difference to the previous row so that rows where the lag goes across two conversations are removed. Then you can use [GroupBy](https://kni.me/n/5stmXk6zY_ORA4bC) to group by Person and Person (-1) and count the occurrence. Does that help? Kind regards, Alexander ---
**Author:** ![HansS](https://forum-cdn.knime.com/user_avatar/forum.knime.com/hanss/32/6979_2.png) [@HansS](https://forum.knime.com/u/HansS)\ **Post date:** [June 6, 2023, 1:23pm UTC](https://forum.knime.com/t/whatsapp-group-chat-analysis-influencer-and-dependents/68515/3 "2023-06-06T13:23:46Z")
Hi @hakandurgut I was thinking of something like this [az chat export analysis v2.knwf](https://forum.knime.com/uploads/short-url/gSg5EGe2ri6m32z3VGkBn40OJ0a.knwf) (546.3 KB). First I identified the different conversations (a new conversation starts when there are no messages posted in de last 10 hours: but that is up to you). Second I analysed every conversation. Finding out who started it and how many messages each person contributed to this conversation. ![image](https://forum-cdn.knime.com/uploads/default/original/3X/1/3/139d21cbc00e4f8c7cdc64d082a2b1e53862ad7c.png) ![image](https://forum-cdn.knime.com/uploads/default/original/3X/e/4/e4e308cadd8c0e91e1e5ea9bb49c2af4337ff002.png) gr. Hans ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [September 4, 2023, 1:24pm UTC](https://forum.knime.com/t/whatsapp-group-chat-analysis-influencer-and-dependents/68515/4 "2023-09-04T13:24:31Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.