Mattermost Lunch Channel History¶
- Data Source: Mattermost API, CCTB instance
- Tasks:
- Part I - June 2024: retrieving chat history data through the mattermost API
- Part II - September 2024: analyzing messages in the lunch channel
- Language: R
Potential questions¶
- At what times is usually posted in the lunch channel
- Extract "the main lunch message" (MLM)
- How many reactions does MLM retrieve
- Is there a correlation by day of week
- Is there a trend over time
- Who posts MLM most often?
- Who attends most often without posting MLM?
- For an individal user get the attendance over time
- …
In [3]:
library(tidyverse)
── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ── ✔ dplyr 1.1.4 ✔ readr 2.1.5 ✔ forcats 1.0.0 ✔ stringr 1.5.1 ✔ ggplot2 3.5.0 ✔ tibble 3.2.1 ✔ lubridate 1.9.3 ✔ tidyr 1.3.1 ✔ purrr 1.0.2
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ── ✖ purrr::%||%() masks base::%||%() ✖ dplyr::filter() masks stats::filter() ✖ dplyr::lag() masks stats::lag() ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
In [4]:
theme_set(theme_light())
In [5]:
set.seed(42)
"Jana Sascha Mike Markus" %>% str_split(" ") %>% unlist %>% sample %>% str_c(collapse=" → ")
Out[5]:
'Jana → Markus → Mike → Sascha'
In [8]:
messages <- read_csv("messages.csv")
reactions <- read_csv("reactions.csv")
files <- read_csv("files.csv")
Rows: 6934 Columns: 6
── Column specification ──────────────────────────────────────────────────────── Delimiter: "," chr (3): post_id, message, username dbl (2): num_reactions, num_files dttm (1): create_at
ℹ Use `spec()` to retrieve the full column specification for this data. ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
Rows: 3611 Columns: 5
── Column specification ──────────────────────────────────────────────────────── Delimiter: "," chr (4): post_id, emoji_name, username, emoji dttm (1): create_at
ℹ Use `spec()` to retrieve the full column specification for this data. ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
Rows: 217 Columns: 3
── Column specification ──────────────────────────────────────────────────────── Delimiter: "," chr (3): post_id, file_id, link
ℹ Use `spec()` to retrieve the full column specification for this data. ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
In [12]:
reactions %>% head
Out[12]:
| post_id | create_at | emoji_name | username | emoji |
|---|---|---|---|---|
| <chr> | <dttm> | <chr> | <chr> | <chr> |
| ng3m9o5c5igw3gpgg1dqmgs4mw | 2017-08-18 11:57:23 | +1 | lulei | 👍 |
| atnyf76f1tb1fmznhrk4s3wohr | 2017-08-21 11:50:04 | +1 | sonja | 👍 |
| atnyf76f1tb1fmznhrk4s3wohr | 2017-08-21 11:52:22 | +1 | iimog | 👍 |
| eh5ge6nnf7np5q61rqpfwhmqaw | 2017-08-23 11:24:45 | +1 | sonja | 👍 |
| eh5ge6nnf7np5q61rqpfwhmqaw | 2017-08-23 11:26:44 | +1 | alexanderkeller | 👍 |
| eh5ge6nnf7np5q61rqpfwhmqaw | 2017-08-23 11:49:19 | +1 | t.paul | 👍 |
In [13]:
messages %>% head
Out[13]:
| post_id | create_at | message | username | num_reactions | num_files |
|---|---|---|---|---|---|
| <chr> | <dttm> | <chr> | <chr> | <dbl> | <dbl> |
| h957oi1t63rf5b6p4pqfhiis5h | 2016-05-02 12:02:13 | Also ich habe etwas dabei | greatfireball | 0 | 0 |
| rpwuii8hci8ezmn3d41u9d58fc | 2016-05-02 12:03:02 | ich gehe mir jetzt was holen | nterhoeven | 0 | 0 |
| e8bnwq8c7fdf5k7zpqyeihougr | 2016-05-02 12:03:24 | Alles klar | greatfireball | 0 | 0 |
| sku34dhpntdfdmc5d9ky9a9yso | 2016-05-02 12:20:33 | Hallo @joerg | greatfireball | 0 | 0 |
| hi38ssjpb3yqz88dk83tzjq5zr | 2016-05-02 12:20:35 | Essen? | greatfireball | 0 | 0 |
| dux74xuq738u38z384wg8mri1e | 2016-05-02 12:20:36 | :smile: | greatfireball | 0 | 0 |
Trying to find MLM¶
In [15]:
messages %>% select(message)
Out[15]:
| message |
|---|
| <chr> |
| Also ich habe etwas dabei |
| ich gehe mir jetzt was holen |
| Alles klar |
| Hallo @joerg |
| Essen? |
| :smile: |
| (wave) auch da! |
| old school |
| :wave: |
| :unicorn_face: |
| Pink fluffy unicorns! |
| :hurtrealbad: |
| :dog: |
| Essen!!!! |
| Go go go |
| wir waren in der Mensa |
| Hat es geschmeckt? |
| Greetings, I’m Awesome. I’m here to make your work flow. Check out `/awesome help` to learn how I can help your team stay in sync and uncover insights right here in Slack. :sparkles: |
| Arthur shared a `/worklog` with ~lunch: |
| Jetzt geht es los... @art spammt die Leute voll :smile: |
| awesome |
| Du klingst noch nicht ganz überzeugt :smile: |
| What about lunch today? |
| I have something |
| i will bring home my dog and come back after lunch |
| I have something, too |
| When will we start? |
| Now |
| essenspläne heute? |
| ich hab nix dabei |
| ⋮ |
| Anyone here for lunch? |
| 11:15? |
| 11:15? |
| 11:15? |
| kitchen lunch anyone? |
| 11:15? |
| 11:16? |
| 11:17? |
| NA |
| lunch anyone? |
| 11:35? |
| kitchen lunch 12:15? |
| 11:15? |
| NA |
| NA |
| 11:15? |
| 11:15? |
| NA |
| 11:15? |
| NA |
| 11:15? |
| 11:15? |
| 11:15? |
| 11:15? |
| lunch? |
| when? |
| 11:15? |
| lunch 11:15? |
| 11:15? |
| 11:15? |
Quality control: Each message contains either text or file
In [17]:
messages %>% filter(is.na(message), num_files == 0)
Out[17]:
| post_id | create_at | message | username | num_reactions | num_files |
|---|---|---|---|---|---|
| <chr> | <dttm> | <chr> | <chr> | <dbl> | <dbl> |
In [18]:
messages %>% count(message, sort=TRUE)
Out[18]:
| message | n |
|---|---|
| <chr> | <int> |
| 11:15? | 99 |
| NA | 94 |
| :+1: | 79 |
| yes | 72 |
| ok | 51 |
| I have something | 40 |
| ? | 37 |
| :thumbsup: | 35 |
| mensa? | 35 |
| check | 33 |
| Mensa? | 29 |
| ich hab was dabei | 26 |
| me too | 24 |
| @kitchengroup lunch at 12? | 23 |
| go | 23 |
| go? | 23 |
| lunch? | 23 |
| jo | 20 |
| now? | 20 |
| ja | 19 |
| jup | 18 |
| coffee? | 17 |
| now | 16 |
| 11:45? | 15 |
| @kitchengroup Lunch at 12? | 15 |
| any lunch plans today? | 13 |
| coffee break? | 13 |
| mensa now? | 13 |
| mensa soon? | 13 |
| mensa 11:25? | 12 |
| ⋮ | ⋮ |
| yes, i come with you | 1 |
| yes, indeed. | 1 |
| yes, me | 1 |
| yes, please! | 1 |
| yes, please, I want a Leberkässemmel | 1 |
| yes, please, thank you! | 1 |
| yes, so they said :D | 1 |
| yes, sounds like a plan | 1 |
| yes. | 1 |
| yesterday at 11:15 it was already very full, so I would go for 11:10 - if not even earlier | 1 |
| you can draw a unicorn for every minute -> 56 unicorns until lunch | 1 |
| you dont have to wait for me enjoy your coffee ^^ | 1 |
| you have to | 1 |
| you mean the interim mensa? | 1 |
| you'll be taking a break soon? | 1 |
| your productive 90mins are over @art | 1 |
| yum | 1 |
| zum Glück ist die Vorlesungszeit vorbei | 1 |
| zur Kaffeepause-Zeitpunkt-Diskussion: Ich werde es vor halb 4 nicht schaffen... | 1 |
| zwei Stücke von der vegetarischen Pizza liegen im Kühlschrank | 1 |
| {mensa,burger}group leave soon? | 1 |
| ~10min? | 1 |
| ~12:15 or so | 1 |
| Übrigens haben wir 23 Euro bezahlt... Ich würde daher von jedem 23/4=5,75€ bekommen | 1 |
| ähh i mean mensagroup? | 1 |
| да | 1 |
| хорошо | 1 |
| | 1 |
| “Where do you want to go today?” was the title of Microsoft’s 2nd global image advertising campaign. | 1 |
| 😍 | 1 |
In [22]:
messages %>% filter(message == "I have something") %>% count(username, sort=TRUE)
Out[22]:
| username | n |
|---|---|
| <chr> | <int> |
| franzi_s | 17 |
| iimog | 12 |
| nterhoeven | 4 |
| sonja | 4 |
| greatfireball | 3 |
In [27]:
messages %>% filter(str_detect(message, "\\?")) %>% count(message, sort=TRUE)
Out[27]:
| message | n |
|---|---|
| <chr> | <int> |
| 11:15? | 99 |
| ? | 37 |
| mensa? | 35 |
| Mensa? | 29 |
| @kitchengroup lunch at 12? | 23 |
| go? | 23 |
| lunch? | 23 |
| now? | 20 |
| coffee? | 17 |
| 11:45? | 15 |
| @kitchengroup Lunch at 12? | 15 |
| any lunch plans today? | 13 |
| coffee break? | 13 |
| mensa now? | 13 |
| mensa soon? | 13 |
| mensa 11:25? | 12 |
| mensa anyone? | 12 |
| mensa 11:45? | 11 |
| Lunch? | 10 |
| Mensa in 10 min? | 10 |
| Mensa in 5 min? | 9 |
| mensa 11:15? | 9 |
| 11:40? | 8 |
| Any lunch plans? | 8 |
| mensa 11:40? | 8 |
| mensa at 1110 ? | 8 |
| mensa in 5? | 8 |
| 10 min? | 7 |
| Mensa anyone? | 7 |
| Mensa now? | 7 |
| ⋮ | ⋮ |
| wie sieht's heute mit Mittagessen aus? | 1 |
| wie siehts aus? | 1 |
| wie siehts mit der Kitchengroup aus? | 1 |
| wie siehts unten rechts mit mensa aus? | 1 |
| wie sind denn die lunch Pläne ?, Ich würde heute glatt mal wieder mit zur Mensa humpeln.... | 1 |
| will noch jemand mitkommen? | 1 |
| wir gehen in die Mensa. Anyone wants to join? | 1 |
| wo willst du denn was holen? tegut? | 1 |
| wollen wir auch bald essen? | 1 |
| wollen wir dann essen? | 1 |
| wollen wir dann lieber in 5 min los? | 1 |
| wollen wir dann los? | 1 |
| wollen wir dann was essen? | 1 |
| wollen wir die Döner dann holen und hier essen? | 1 |
| wollen wir essen? | 1 |
| wollen wir heute früh essen? | 1 |
| wollen wir los? | 1 |
| wollen wir uns nach dem essen mal dem zelt widmen? | 1 |
| would anyone like to go to the Hubland Restaurant? | 1 |
| wow, that is interesting, na gut dann würde ich sagen lieber 3 minuten eher los gehen ?? | 1 |
| wäre jemand so nett und würde mir was aus der cafete mitbringen? | 1 |
| wäre sonst jemand bei einem Küchensnack dabei? :) | 1 |
| yes - 10 minutes? | 1 |
| yes, but when? | 1 |
| you mean the interim mensa? | 1 |
| you'll be taking a break soon? | 1 |
| {mensa,burger}group leave soon? | 1 |
| ~10min? | 1 |
| ähh i mean mensagroup? | 1 |
| “Where do you want to go today?” was the title of Microsoft’s 2nd global image advertising campaign. | 1 |
In [30]:
messages %>% filter(str_detect(message, "\\d\\d:\\d\\d")) %>% count(message, sort = TRUE)
Out[30]:
| message | n |
|---|---|
| <chr> | <int> |
| 11:15? | 99 |
| 11:45? | 15 |
| mensa 11:25? | 12 |
| mensa 11:45? | 11 |
| mensa 11:15? | 9 |
| 11:40? | 8 |
| mensa 11:40? | 8 |
| mensa 11:20? | 7 |
| mensa at 11:25? | 7 |
| 11:15? :eyes: | 6 |
| 11:25? | 5 |
| Mensa 11:15? | 5 |
| 11:20? | 4 |
| 12:30 lunch? | 4 |
| Lunch 11:15? | 4 |
| Mensa 11:25? | 4 |
| 11:30? | 3 |
| 12:00? | 3 |
| 12:30? | 3 |
| 15:30? | 3 |
| mensa at 11:15? | 3 |
| 12:00 | 2 |
| 12:30 sounds good | 2 |
| 15:30 | 2 |
| 15:30 coffee? | 2 |
| Lunch at 11:20? | 2 |
| Mensa 11:20? | 2 |
| Mensa at 11:25? | 2 |
| Mensa at 11:45? | 2 |
| Mensa um 11:25? | 2 |
| ⋮ | ⋮ |
| red brickhouse burger bar team: 11:50 confirmed | 1 |
| shall we go 11:30? | 1 |
| shall we go 11:45 and meet back here at 12? | 1 |
| short (!) Mate break at 14:00 | 1 |
| should we make a coffee break at 16:15? | 1 |
| so 12:15? | 1 |
| so 12:30 for me | 1 |
| so gegen 12:32 ? | 1 |
| so it is 12:30 | 1 |
| später heisst 12:30? | 1 |
| sun 12:15? | 1 |
| sure, we will probably go at 11:20 | 1 |
| tee um 16:40? | 1 |
| today again ca. 12:45? | 1 |
| today again early mensa 11:44? | 1 |
| um 12:30? | 1 |
| we are about finished here, mensa 12:15 could work | 1 |
| we decided with Franzi M to go around 12:30 pm | 1 |
| we go to mensa for another tagliata or a cheeseburger ca 12:15 | 1 |
| we will go mensa around 12:15 or so... | 1 |
| well as we have lunch normally at 11:45, 12:30 is nearly dinner time for me :slightly_smiling_face: | 1 |
| what about early mensa today - 11:45? | 1 |
| when are you done 16:00? | 1 |
| when do you want to order, will only come to CCTB around 11:30 | 1 |
| wir haben sicherheitsbelehrung von 11:30 -12:30, werde also nicht mit dabei sein beim mittagessen | 1 |
| wir schaffen nicht mehr vor 12:45 zurück zu sein | 1 |
| would rather vote for 12:25 again... | 1 |
| yes - around 12:15 would be perfect so I can move on to the BZ afterwards | 1 |
| yesterday at 11:15 it was already very full, so I would go for 11:10 - if not even earlier | 1 |
| ~12:15 or so | 1 |
In [0]:
In [32]:
messages %>% filter(message == "short (!) Mate break at 14:00")
Out[32]:
| post_id | create_at | message | username | num_reactions | num_files |
|---|---|---|---|---|---|
| <chr> | <dttm> | <chr> | <chr> | <dbl> | <dbl> |
| rrc6dqeaj78k9xxe4rwnzz7r4y | 2022-07-19 13:50:15 | short (!) Mate break at 14:00 | janablechschmidt | 0 | 0 |
In [35]:
messages %>% filter(create_at > ymd_hms("2022-07-19 13:50:15")) %>% head(3)
Out[35]:
| post_id | create_at | message | username | num_reactions | num_files |
|---|---|---|---|---|---|
| <chr> | <dttm> | <chr> | <chr> | <dbl> | <dbl> |
| rrc6dqeaj78k9xxe4rwnzz7r4y | 2022-07-19 13:50:15 | short (!) Mate break at 14:00 | janablechschmidt | 0 | 0 |
| ysj63h435jng5f4ueqm6ksjd4a | 2022-07-20 07:09:50 | there is ice cream in the fridge to make the heat more bearable :sunny: :icecream: | janablechschmidt | 5 | 0 |
| j5rf7bkxbpn6tnynj55xcdhyta | 2022-07-20 12:24:43 | lunch at 12:27? | maximilian_p | 0 | 0 |
Is the first message of the day the MLM (in most cases)?¶
In [72]:
MLM <- messages %>%
mutate(my_day = floor_date(create_at, "day")) %>%
group_by(my_day) %>% filter(row_number() == 1)
In [73]:
MLM
Out[73]:
| post_id | create_at | message | username | num_reactions | num_files | my_day |
|---|---|---|---|---|---|---|
| <chr> | <dttm> | <chr> | <chr> | <dbl> | <dbl> | <dttm> |
| h957oi1t63rf5b6p4pqfhiis5h | 2016-05-02 12:02:13 | Also ich habe etwas dabei | greatfireball | 0 | 0 | 2016-05-02 |
| hmdk3e5w1pf5xptgxr9hc6niqy | 2016-05-03 11:24:55 | What about lunch today? | greatfireball | 0 | 0 | 2016-05-03 |
| yepxejb3ejnj9nmsb75eod1bga | 2016-05-04 11:30:47 | essenspläne heute? | nterhoeven | 0 | 0 | 2016-05-04 |
| 6hmbwo4exjroxgbixdpo6f64ar | 2016-05-06 11:33:50 | What are the plans for today? | iimog | 0 | 0 | 2016-05-06 |
| pqrbzh9zb7f67qoodx14qyeoiw | 2016-05-09 11:28:43 | Wie sieht es denn heute mit Essensplänen aus? Ich müsste mir was holen. | franzi_s | 0 | 0 | 2016-05-09 |
| 8yinzh7xhpbxtr71cgwewtoz7e | 2016-05-10 10:42:33 | Hey... What about lunch today? I have something... | greatfireball | 0 | 0 | 2016-05-10 |
| x3epctasxt837dnm7f8e1ktn4o | 2016-05-11 11:40:11 | any lunch plans today? | nterhoeven | 0 | 0 | 2016-05-11 |
| o57a67njpbbbjnhwgky74co1ah | 2016-05-12 10:12:09 | Plans for today? Already have something :simple_smile: | greatfireball | 0 | 0 | 2016-05-12 |
| ynfbrs46ef86783nyd5dxqu7yy | 2016-05-17 11:07:50 | any plans for lunch today? | nterhoeven | 0 | 0 | 2016-05-17 |
| mzsefre4i7bymgxpmnf6ub6ffo | 2016-05-18 11:26:15 | What about lunch today? | franzi_s | 0 | 0 | 2016-05-18 |
| ij8mdy71bprtunm7sa6omrq71r | 2016-05-19 11:50:27 | wie schaut's heute bei euch mit Essen aus? | nterhoeven | 0 | 0 | 2016-05-19 |
| htga8wqru3y1xmy56w9t1kx4xc | 2016-05-24 11:47:58 | When should we go to the mensa today? | jscabral | 0 | 0 | 2016-05-24 |
| xtqwm174ajrsjxj4xyebkem5ih | 2016-05-25 11:49:03 | today again ca. 12:45? | jscabral | 0 | 0 | 2016-05-25 |
| mwtp6ckh1pr49c8x6rgci48mnh | 2016-05-27 11:50:58 | anyone hungry already? | philip_k | 0 | 0 | 2016-05-27 |
| cwpdoh5sgbgm5m6kbwbxjwbxmo | 2016-05-30 11:46:56 | any plans for lunch today? | nterhoeven | 0 | 0 | 2016-05-30 |
| ktfeoj5ea7yc8dh6w1cw7ugyae | 2016-05-31 11:43:26 | wer ist denn heute eigentlich zum Essen da? | nterhoeven | 0 | 0 | 2016-05-31 |
| x9i5js9rw3nz9dwb54rp6onzfy | 2016-06-01 11:54:40 | wie schaut's bei euch mit hunger aus? | nterhoeven | 0 | 0 | 2016-06-01 |
| 5wp61mc9ipbdze1a59iret6x8y | 2016-06-02 11:59:27 | wie schaut's denn bei euch mit essen aus? | nterhoeven | 0 | 0 | 2016-06-02 |
| p119p4bf97nopn3b8861qeh1xo | 2016-06-03 12:07:54 | hat jemand von euch essenspläne? | nterhoeven | 0 | 0 | 2016-06-03 |
| 7adjii9atbdabnfynsenjxtepa | 2016-06-06 12:09:51 | Ich würde jetzt gleich zur mensateria laufen und mir was zu Essen holen | nterhoeven | 0 | 0 | 2016-06-06 |
| n8amu7osxpncp84m9mywtsy6fr | 2016-06-08 12:36:35 | Wie sieht es heute mit Essensplänen aus? | franzi_s | 0 | 0 | 2016-06-08 |
| i935rkig6jn3zq1g6tgw7d4aow | 2016-06-13 11:58:26 | Ich würde mir demnächst in der Mensateria ein Brötchen holen. Sonst noch jemand? | iimog | 0 | 0 | 2016-06-13 |
| 38h7i6e6qfd6by571fhpaxs96w | 2016-06-14 11:48:31 | irgendwelche Essenspläne heute? | franzi_s | 0 | 0 | 2016-06-14 |
| 5arkrb6icpr5mrx5q7ts4ze5mh | 2016-06-15 11:53:52 | any plans for lunch today? | franzi_s | 0 | 0 | 2016-06-15 |
| u5g43wmc1pgydmkewf91ud9sxr | 2016-06-16 11:53:41 | whats the plan today? i have to pick up something to eat | alexanderkeller | 0 | 0 | 2016-06-16 |
| oruix8axq7bxfqppj5iyxu87sa | 2016-06-17 11:50:38 | Any lunch plans today? | nterhoeven | 0 | 0 | 2016-06-17 |
| sawymxyq9iyhdbcm9whk1zwe3c | 2016-06-20 11:12:51 | wäre heut beim lunch dabei | wiebke | 0 | 0 | 2016-06-20 |
| i6hmnb34gig9zbajwj89h65chr | 2016-06-22 11:52:08 | any lunch plans today? | nterhoeven | 0 | 0 | 2016-06-22 |
| 1mmw4pzg7fgjircmmwouw7ipwh | 2016-06-23 12:25:46 | hey, lunchtime? | jscabral | 0 | 0 | 2016-06-23 |
| 5jajixm46id4iygxdhricchrpe | 2016-06-24 11:49:30 | How about lunch today? Niklas and me will either pich something from the cafeteria or go to the mensateria soon. Anybody else interested in food? | iimog | 0 | 0 | 2016-06-24 |
| ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ | ⋮ |
| j48cnpyk9bynp8nuaczdtz16dh | 2024-07-17 12:11:01 | Now | iimog | 2 | 0 | 2024-07-17 |
| y1k7i6upntnupj9xptre6kd1iy | 2024-07-19 11:05:51 | anyone here for lunch? | felixfink | 0 | 0 | 2024-07-19 |
| kynf489tqpb4mrk3ao31pxpqro | 2024-07-22 10:58:42 | Anyone here for lunch? | sabine | 2 | 0 | 2024-07-22 |
| 4dk3qq8kubyg7dum3isioasr3y | 2024-07-23 10:48:44 | 11:15? | robin | 2 | 1 | 2024-07-23 |
| 4t3k8eb6kbf6i87e9q9w87kdba | 2024-07-25 11:00:19 | 11:15? | felixfink | 1 | 0 | 2024-07-25 |
| pidtbmc4qjgb9fratwco735osy | 2024-07-26 10:19:37 | Lunch 1130/1145? | felixfink | 1 | 0 | 2024-07-26 |
| hmj85r9r6byh7kpze9fmq7tr9y | 2024-07-29 10:58:06 | 11:15? | felixfink | 2 | 1 | 2024-07-29 |
| 3krp8is4ob8axp5cr4115on59w | 2024-07-30 10:24:09 | 11:15? | david | 1 | 0 | 2024-07-30 |
| pexikanbztr7ifm64eirofwh9h | 2024-07-31 13:05:09 | es sind 5,60€ :relaxed: paypal jblechschmidt13@gmail.com oder in bar bitte danke | janablechschmidt | 0 | 0 | 2024-07-31 |
| qqzrwj8dqjf47r1ctm8u43mc3c | 2024-08-01 10:54:55 | Anyone here for lunch? | felixfink | 1 | 1 | 2024-08-01 |
| ub4zm7unpbgdfbro7hwzxr6xjo | 2024-08-02 10:51:12 | 11:15? | robin | 3 | 1 | 2024-08-02 |
| 36wteq5ef3fndpnxwf4re5m5jy | 2024-08-05 10:56:17 | 11:15? | felixfink | 1 | 1 | 2024-08-05 |
| znq5zkuk8bnbupc4z616daomwa | 2024-08-06 10:52:58 | 11:15? | felixfink | 1 | 0 | 2024-08-06 |
| t8mnuirj7ingbfwihfh1fpbxra | 2024-08-07 11:08:26 | 11:16? | iimog | 4 | 0 | 2024-08-07 |
| cssnpiukwifd58iyw4dzssd7qa | 2024-08-08 10:45:56 | 11:17? | iimog | 1 | 0 | 2024-08-08 |
| nkm1mg51dty55b9ghzsppjcw4e | 2024-08-12 11:03:00 | NA | felixfink | 1 | 1 | 2024-08-12 |
| j4q6fu33ofyi3pt1y6q9q1k19o | 2024-08-13 11:30:01 | lunch anyone? | felixfink | 1 | 0 | 2024-08-13 |
| 7fburkqmh7fa7q35iohuiz1iqe | 2024-08-14 10:42:46 | 11:15? | robin | 2 | 1 | 2024-08-14 |
| uwirpgowu7nqipfjkki64gaedy | 2024-08-19 10:49:02 | 11:15? | robin | 4 | 1 | 2024-08-19 |
| tsonz19q3jrm8pp3f8o5ccboto | 2024-08-20 10:25:06 | 11:15? | david | 2 | 0 | 2024-08-20 |
| nejc3nh1offzdp7bmgpnqe8ekr | 2024-08-21 10:50:57 | NA | felixfink | 3 | 1 | 2024-08-21 |
| i5wt4fnqopygzjxfuum8br19wr | 2024-08-22 10:45:31 | 11:15? | david | 0 | 0 | 2024-08-22 |
| 3mkddbhfftbmjecwinq7nuy6zw | 2024-08-23 10:38:44 | 11:15? | robin | 2 | 1 | 2024-08-23 |
| k7qp798w4t8hppx8myzn3x6khc | 2024-08-26 11:00:43 | 11:15? | felixfink | 4 | 0 | 2024-08-26 |
| o84wq6g8jjfipj8aqj5b1j761o | 2024-08-27 10:37:48 | 11:15? | david | 4 | 0 | 2024-08-27 |
| yqhxnkrcit8k8dywm75d1oyjiy | 2024-08-28 10:35:52 | 11:15? | felixfink | 7 | 0 | 2024-08-28 |
| jqnbok68gpd45mg3tg87gzda3a | 2024-08-29 11:03:48 | lunch? | david | 0 | 0 | 2024-08-29 |
| d3dxbcsmyi8i7rae83hn6m6aue | 2024-08-30 11:09:52 | lunch 11:15? | felixfink | 2 | 0 | 2024-08-30 |
| gnamzgc7gprzzch6kpio9emwjy | 2024-09-02 11:01:02 | 11:15? | felixfink | 5 | 1 | 2024-09-02 |
| mputf8b3mpygu8td7hr9nmnw3r | 2024-09-03 11:00:22 | 11:15? | felixfink | 7 | 1 | 2024-09-03 |
In [66]:
MLM %>% filter(num_reactions > 6) %>% arrange(-num_reactions)
Out[66]:
| post_id | create_at | message | username | num_reactions | num_files | my_day |
|---|---|---|---|---|---|---|
| <chr> | <dttm> | <chr> | <chr> | <dbl> | <dbl> | <dttm> |
| ny6cuue9ni8aikah6jgcterg7a | 2018-02-28 09:51:48 | Heute gibt es Kuchen | williamlopez | 15 | 0 | 2018-02-28 |
| obxcr16ckbfwmrri6hfmqqyz4e | 2024-04-06 21:28:55 | For the cooking session on Wednesday, I selected Spätzle with melted cheese and onions (plus cucumber salad). Please react until Tuesday if you want to participate, and contact me if you need a vegan option or if you have other dietary requirements. | iimog | 13 | 0 | 2024-04-06 |
| pneqq41bsfrt5gc74onrrzrhrw | 2023-09-20 10:41:54 | I'm probably in a meeting until ~11:30 lunch after? | robinroelz | 11 | 0 | 2023-09-20 |
| 83yipzcknf8rukcjcxasq36e3h | 2019-04-10 11:42:43 | :plate_with_cutlery: | lulei | 9 | 0 | 2019-04-10 |
| 5wgrqojm1ffizet76dtswhdeuh | 2019-05-02 11:32:23 | soon ? | art | 9 | 0 | 2019-05-02 |
| 6afg99bst78tmqu6suc8y4wkoc | 2022-10-11 10:37:00 | :fallen_leaf: There is chocolate cake^ in the kitchen :fallen_leaf: ^ *non-vegan, but gluten-free* | anne.lewerentz | 9 | 0 | 2022-10-11 |
| euycyp3hppnktbju1s7nzr9ctr | 2024-02-08 10:40:42 | Hi all! Today is one of the most important holidays in a calendar of every polish person: a Fat Thursday (https://en.wikipedia.org/wiki/Fat_Thursday) a holiday that is all about eating your weight in deep fried stuff in the name of tradition. To get you all started on that noble task I have brought my best attempt at recreating classic polish donuts - Pączki. They are waiting for you in the kitchen, please help yourselves! | gosia | 9 | 0 | 2024-02-08 |
| ny6z6rxo7j8pumzuwzu48kny6a | 2019-07-02 11:29:03 | Burger time 11:45? | t.paul | 8 | 0 | 2019-07-02 |
| 6utpobi5z3fiucmxdesjrwzdkw | 2021-10-12 10:42:55 | I brought vegan / vegetarian / fish - Sushi for around 10 people. Who would like to join at 12:00 for :sushi: lunch in the kitchen? | anne.lewerentz | 8 | 0 | 2021-10-12 |
| 5yzbsqkfrjn4dpjaih67dkp8gc | 2022-09-23 11:14:29 | :fries: ? | felixfink | 8 | 1 | 2022-09-23 |
| 6s5t7ee5xpfn9da3r7khehkuny | 2024-01-30 09:41:00 | There are some sweets from my region in India in the kitchen, do help yourselves :) | dharanish | 8 | 0 | 2024-01-30 |
| y6xc3s3ikbbbdd9mag6joi5jja | 2019-05-09 11:32:42 | :question: | roman | 7 | 0 | 2019-05-09 |
| 7k8n6thsa3n8pefimfi4d1xcny | 2019-05-16 11:41:30 | Anybody mensa today? :) | anda | 7 | 0 | 2019-05-16 |
| pngnie4zh7ff9psbi733qmuone | 2021-01-12 12:18:48 | Voting: Shall we do today a real lunch :dancing_men: or virtual lunch :computer: ? | anne.lewerentz | 7 | 0 | 2021-01-12 |
| 38fg9zjoftfejrw8mds7cikzhe | 2021-10-21 09:07:17 | there are plätzchen in the kitchen for everyone :christmas_tree: | janablechschmidt | 7 | 0 | 2021-10-21 |
| szjukezgppn8zqqptzmeifsder | 2022-08-25 11:11:45 | mensa 11:25? | simon.schardt | 7 | 0 | 2022-08-25 |
| rzbm9r7u6tydmy4bdykd65sxie | 2022-09-22 11:19:21 | Mensa at 11:25? | mike_k | 7 | 0 | 2022-09-22 |
| oq64nojfdjgp3phmsteecrw7wo | 2022-12-09 08:40:07 | there is apple pie in the kitchen :pie: happy friday! | janablechschmidt | 7 | 0 | 2022-12-09 |
| jm6depk1zifk7bux9jrusn1zsr | 2023-03-14 11:03:02 | Mensa at 1114 ? | andreaskuhn | 7 | 0 | 2023-03-14 |
| c558ys5493ygfnm4g1qypgfs5o | 2023-03-21 11:07:22 | Mensa at 1119 ? | andreaskuhn | 7 | 0 | 2023-03-21 |
| 8in63wb5ibdfzq1kptk9mudgrh | 2023-04-20 11:02:22 | Mensa 11:15? | robinroelz | 7 | 0 | 2023-04-20 |
| 8kg4uj56ffrfuyy3fc4koixtgw | 2023-06-19 10:52:38 | NA | maximilian_p | 7 | 1 | 2023-06-19 |
| pneds7homj8r7qtegjcrkiyqpr | 2023-06-26 11:01:49 | NA | maximilian_p | 7 | 1 | 2023-06-26 |
| 5qp4anh613rkjfti66zikjc8ay | 2023-10-19 10:43:26 | 11.10? | lisamrshhsr | 7 | 1 | 2023-10-19 |
| gxnbob4i4pnk5f5u614kr8zbpc | 2023-12-01 10:58:27 | Lunch at 11:15? | angie | 7 | 1 | 2023-12-01 |
| eip79sun8igdzf64xb1umbpoow | 2024-01-22 10:42:51 | Mensa 11:15? | marko_korb | 7 | 0 | 2024-01-22 |
| inwierjsufdc7b1z9ude4kaxch | 2024-01-26 10:52:06 | Mensa at 11:15? | angie | 7 | 1 | 2024-01-26 |
| yqhxnkrcit8k8dywm75d1oyjiy | 2024-08-28 10:35:52 | 11:15? | felixfink | 7 | 0 | 2024-08-28 |
| mputf8b3mpygu8td7hr9nmnw3r | 2024-09-03 11:00:22 | 11:15? | felixfink | 7 | 1 | 2024-09-03 |
In [64]:
MLM %>% ggplot(aes(y = num_reactions, x = my_day)) +
geom_point()
Out[64]:
In [68]:
messages %>% ggplot(aes(y = num_reactions, x = create_at)) +
geom_point()
Out[68]:
In [69]:
messages %>% filter(num_reactions > 6) %>% arrange(-num_reactions)
Out[69]:
| post_id | create_at | message | username | num_reactions | num_files |
|---|---|---|---|---|---|
| <chr> | <dttm> | <chr> | <chr> | <dbl> | <dbl> |
| ny6cuue9ni8aikah6jgcterg7a | 2018-02-28 09:51:48 | Heute gibt es Kuchen | williamlopez | 15 | 0 |
| obxcr16ckbfwmrri6hfmqqyz4e | 2024-04-06 21:28:55 | For the cooking session on Wednesday, I selected Spätzle with melted cheese and onions (plus cucumber salad). Please react until Tuesday if you want to participate, and contact me if you need a vegan option or if you have other dietary requirements. | iimog | 13 | 0 |
| wr7pb8n6cif7tdda9cmzek3k8c | 2022-05-10 14:06:50 | Our first CCTB cooking session was a success, thanks Jana for organizing :relaxed: The next session is planned for Tuesday, the 31st of May. Feel free to join and sign up in the pad: https://hackmd.io/PhOpF6VoQN2D9Mg6R3K9bQ?view | kerstin | 12 | 1 |
| pneqq41bsfrt5gc74onrrzrhrw | 2023-09-20 10:41:54 | I'm probably in a meeting until ~11:30 lunch after? | robinroelz | 11 | 0 |
| guom6u5mg3y8pmpmh6on4qh6mw | 2021-10-11 11:08:46 | Happy birthday, Anne!! :tada: :dizzy: :birthday: :muscle: :champagne: The cake is delicious btw, thanks! | jscabral | 10 | 0 |
| 83yipzcknf8rukcjcxasq36e3h | 2019-04-10 11:42:43 | :plate_with_cutlery: | lulei | 9 | 0 |
| 5wgrqojm1ffizet76dtswhdeuh | 2019-05-02 11:32:23 | soon ? | art | 9 | 0 |
| 6afg99bst78tmqu6suc8y4wkoc | 2022-10-11 10:37:00 | :fallen_leaf: There is chocolate cake^ in the kitchen :fallen_leaf: ^ *non-vegan, but gluten-free* | anne.lewerentz | 9 | 0 |
| qjdrbg73wtdyjgpi4n8xa3cq5c | 2023-11-10 10:45:04 | Mensa at 1115 ? | andreaskuhn | 9 | 0 |
| euycyp3hppnktbju1s7nzr9ctr | 2024-02-08 10:40:42 | Hi all! Today is one of the most important holidays in a calendar of every polish person: a Fat Thursday (https://en.wikipedia.org/wiki/Fat_Thursday) a holiday that is all about eating your weight in deep fried stuff in the name of tradition. To get you all started on that noble task I have brought my best attempt at recreating classic polish donuts - Pączki. They are waiting for you in the kitchen, please help yourselves! | gosia | 9 | 0 |
| ny6z6rxo7j8pumzuwzu48kny6a | 2019-07-02 11:29:03 | Burger time 11:45? | t.paul | 8 | 0 |
| 6utpobi5z3fiucmxdesjrwzdkw | 2021-10-12 10:42:55 | I brought vegan / vegetarian / fish - Sushi for around 10 people. Who would like to join at 12:00 for :sushi: lunch in the kitchen? | anne.lewerentz | 8 | 0 |
| 5yzbsqkfrjn4dpjaih67dkp8gc | 2022-09-23 11:14:29 | :fries: ? | felixfink | 8 | 1 |
| 6s5t7ee5xpfn9da3r7khehkuny | 2024-01-30 09:41:00 | There are some sweets from my region in India in the kitchen, do help yourselves :) | dharanish | 8 | 0 |
| jrse9za9bfrd9c937no3up8eth | 2018-09-19 11:28:51 | mensa at 12? :) | anda | 7 | 0 |
| br31bf8uttfajfmbnjkz4gg15r | 2019-04-11 11:37:17 | in 10 min? | sabine | 7 | 0 |
| y6xc3s3ikbbbdd9mag6joi5jja | 2019-05-09 11:32:42 | :question: | roman | 7 | 0 |
| 7k8n6thsa3n8pefimfi4d1xcny | 2019-05-16 11:41:30 | Anybody mensa today? :) | anda | 7 | 0 |
| pngnie4zh7ff9psbi733qmuone | 2021-01-12 12:18:48 | Voting: Shall we do today a real lunch :dancing_men: or virtual lunch :computer: ? | anne.lewerentz | 7 | 0 |
| 38fg9zjoftfejrw8mds7cikzhe | 2021-10-21 09:07:17 | there are plätzchen in the kitchen for everyone :christmas_tree: | janablechschmidt | 7 | 0 |
| z3m6c1qrrjrxjkk9x83m9f31sh | 2022-01-31 13:08:42 | So, I made this Donauwelle-inspired frozen joghurt vegan cake... I thought I'm not good with baking, but apparently I'm not good with freezing either. I swear this morning was looking better, but the transport totally killed it :sweat_smile: it has to cool down again a bit before we can see if the taste can make up for the esthetic. | anda | 7 | 1 |
| szjukezgppn8zqqptzmeifsder | 2022-08-25 11:11:45 | mensa 11:25? | simon.schardt | 7 | 0 |
| rzbm9r7u6tydmy4bdykd65sxie | 2022-09-22 11:19:21 | Mensa at 11:25? | mike_k | 7 | 0 |
| oq64nojfdjgp3phmsteecrw7wo | 2022-12-09 08:40:07 | there is apple pie in the kitchen :pie: happy friday! | janablechschmidt | 7 | 0 |
| jm6depk1zifk7bux9jrusn1zsr | 2023-03-14 11:03:02 | Mensa at 1114 ? | andreaskuhn | 7 | 0 |
| c558ys5493ygfnm4g1qypgfs5o | 2023-03-21 11:07:22 | Mensa at 1119 ? | andreaskuhn | 7 | 0 |
| 8in63wb5ibdfzq1kptk9mudgrh | 2023-04-20 11:02:22 | Mensa 11:15? | robinroelz | 7 | 0 |
| 7oi1tfqqnirhjddaxxj1ft4goy | 2023-05-17 13:17:12 | Sarımsaklı Köfte Dumpling dough (10-12 people): 1 kg of bulgur 500 g flour some salt beer cumin a spoonful of tomato paste some pepper Making part: First, soak the bulgur in 6-7 glasses of warm water and cover it with a lid (wait 20-30 minutes). Then add the spices and mix. You have to knead the flour slowly. And when it is like dough, it is shaped. Add the boiling water (lemon and salt are added to the water), and the köftes should be cooked until they reach the surface of the water. For the sauce: Grate 9-10 tomatoes grated in garlic Making part: Add tomatoes to 1 cup of oil. some paprika some black pepper some salt is added Add 4-5 tablespoons of tomato paste Then add the grated garlic and the sauce will boil a little. Köftes and sauce are mixed and ready to serve (note, parsley is also sprinkled on the last mixture) | leylasrknt | 7 | 0 |
| 8kg4uj56ffrfuyy3fc4koixtgw | 2023-06-19 10:52:38 | NA | maximilian_p | 7 | 1 |
| pneds7homj8r7qtegjcrkiyqpr | 2023-06-26 11:01:49 | NA | maximilian_p | 7 | 1 |
| gdfhdrr9zigupn1ytuyotkh8py | 2023-09-22 10:21:21 | 11.10? | lisamrshhsr | 7 | 0 |
| yp73n9ry1bdz5dc69fo68r4jqw | 2023-10-06 10:49:00 | 11.10? | lisamrshhsr | 7 | 1 |
| 5qp4anh613rkjfti66zikjc8ay | 2023-10-19 10:43:26 | 11.10? | lisamrshhsr | 7 | 1 |
| gxnbob4i4pnk5f5u614kr8zbpc | 2023-12-01 10:58:27 | Lunch at 11:15? | angie | 7 | 1 |
| eip79sun8igdzf64xb1umbpoow | 2024-01-22 10:42:51 | Mensa 11:15? | marko_korb | 7 | 0 |
| inwierjsufdc7b1z9ude4kaxch | 2024-01-26 10:52:06 | Mensa at 11:15? | angie | 7 | 1 |
| yqhxnkrcit8k8dywm75d1oyjiy | 2024-08-28 10:35:52 | 11:15? | felixfink | 7 | 0 |
| mputf8b3mpygu8td7hr9nmnw3r | 2024-09-03 11:00:22 | 11:15? | felixfink | 7 | 1 |
In [71]:
MLM %>% group_by(username) %>% summarize(mnr = mean(num_reactions)) %>% arrange(-mnr)
Out[71]:
| username | mnr |
|---|---|
| <chr> | <dbl> |
| williamlopez | 15.00000000 |
| dharanish | 8.00000000 |
| gosia | 5.00000000 |
| bettinavignolo | 4.00000000 |
| melanie | 3.71428571 |
| marko_korb | 3.50000000 |
| prithivi | 3.50000000 |
| angie | 3.16666667 |
| rosina_ | 3.14285714 |
| lisamrshhsr | 3.09090909 |
| maximilian_p | 2.96000000 |
| felixfink | 2.92857143 |
| david | 2.81250000 |
| carolin_artmann | 2.68750000 |
| andreaskuhn | 2.64583333 |
| robin | 2.56521739 |
| janablechschmidt | 2.50000000 |
| robinroelz | 2.45977011 |
| anda | 2.33333333 |
| andib | 2.33333333 |
| mike_k | 2.27272727 |
| simon.schardt | 2.27272727 |
| chris_n_k | 2.19230769 |
| roman | 2.15789474 |
| kerstin | 2.12857143 |
| lauracecchino | 2.00000000 |
| danielv | 1.85714286 |
| laurasteinmann | 1.77777778 |
| sabine | 1.62068966 |
| sascha_ollertz | 1.41666667 |
| anne.lewerentz | 1.40000000 |
| art | 1.02898551 |
| t.paul | 1.00746269 |
| ariel_cedillo | 1.00000000 |
| leylasrknt | 1.00000000 |
| ludmillafigueiredo | 1.00000000 |
| lulei | 0.97058824 |
| janfreudenthal | 0.84810127 |
| chaitanya | 0.83333333 |
| iimog | 0.80722892 |
| jscabral | 0.76595745 |
| philip_k | 0.50909091 |
| sonja | 0.33333333 |
| martinhochheimer | 0.25000000 |
| franzi_s | 0.20430108 |
| simon_p | 0.09677419 |
| alexanderkeller | 0.06060606 |
| nterhoeven | 0.03225806 |
| alexandra_sprenger | 0.00000000 |
| annavk | 0.00000000 |
| greatfireball | 0.00000000 |
| hannananna | 0.00000000 |
| jana | 0.00000000 |
| joerg | 0.00000000 |
| mariath | 0.00000000 |
| philippmostosi | 0.00000000 |
| rick | 0.00000000 |
| stefan_fallert | 0.00000000 |
| wiebke | 0.00000000 |