https://discord.com/channels/1110799176264056863/1111541184490393691/1262798808308256888

Saw in 0.30.0. Should be reproducible in 0.31.0 as 0.30.0 were only RLN_v2 changes.


Logs given by Zoltan where we can see the issue:

lpt_duptest.zip

The files contain logs from 40 waku nodes, and as extra files, a log from a lightpush node, and a filter node. In total, we have 42 nodes.

Running the analysis on the logs, we obtain the following report:

src.mesh_analysis.waku_message_log_analyzer - INFO - Analyzing from local
src.mesh_analysis.readers.file_reader - INFO - Reading lpt_duptest
src.mesh_analysis.readers.file_reader - INFO - Tracing lpt_duptest
src.mesh_analysis.tracers.waku_tracer - INFO - Nº of Peers: 40
src.mesh_analysis.tracers.waku_tracer - INFO - Nº of unique messages: 30000
src.mesh_analysis.tracers.waku_tracer - WARNING - Some peers missed messages: ['16U*156L2V', '16U*1uEcvU', '16U*2qs5TA', '16U*4q1Z1j', '16U*5KgA1P', '16U*7NQ2bS', '16U*BCiJTJ', '16U*BaAvHb', '16U*EooLc3', '16U*H6JKiN', '16U*HKS7Bx', '16U*Jgmzwu', '16U*KwriRM', '16U*Pter8V', '16U*RETLKh', '16U*S1bbQ5', '16U*Ts57n5', '16U*UwNRJr', '16U*WqokQX', '16U*Wy4bKk', '16U*XKB9K5', '16U*YPrMNJ', '16U*cPKVoR', '16U*dPRM2v', '16U*eX55R1', '16U*ed2Ek9', '16U*gUf8Lc', '16U*heniGe', '16U*i7nh2r', '16U*iFhFPb', '16U*k43a4R', '16U*o7Azzw', '16U*pQWAu5', '16U*qWnooT', '16U*qcyJ5n', '16U*tabRWV', '16U*tni4YW', '16U*ufSvgb', '16U*vqRnxc', '16U*xLd7C9']
src.mesh_analysis.tracers.waku_tracer - WARNING - Missing messages: ['0x045ff4b1f8fa9b9f5df42d7e7ff853b2436a91cd15940f0fcd3a2d73ea0f80ad', '0x076a9937081cd19ca39d57e8c7af81ca1afa522ef128fac037828ea68dc99c76', '0x09ece248a8482da5b96cbd3767843a0a7c96d52a41a8a78e4a70001339a4b4d7', '0x0ae1638f9d743d55490b590c42f0f769957a189e30338e6086d3e31a1e9d5a90', '0x0c929ff039e39e995f9443cc91e875868a64b6cb9e0e8553c64ea427a2d75ac9', '0x0d5ac5f50e8a2a3cd1f635155078cc7b74086d0e9e7c84cf47f2b171308e982a', '0x0db6dd55bba24e69dc541f59532b99f6fb1fde6949757918c3842814039757e4', '0x12c3f19f7a808bda2ac603e1904cd41c5ecb0ec6ef51963eef3af263a9e59b89', '0x14737b4900d2d51790d961b3ee70fa3fd3d74eeb402ed16c1fb6b8e52a977d47', '0x1566ce62faeabba266b3c8dfe84d3f1e81d032870d1d201b50b425e6d4feae95', '0x166c30cdb505ed7e8ab59e13aae036b023ed0cc82adbe488772fad5941d00fed', '0x1d5e68dd83540c5baa9eac97e8f1c6d0adaebc5b72697f7b1fc609d63a9aec15', '0x2024564fe741eb298cc3548da1867ee8f87fc33452541303e82a9cca68576950', '0x206335acc7b68fc600f9af4192ab766c42d56494858862d9893e205378720cbb', '0x2099a29141b838fee06cf15220946415228eeb224cb4635f3d5e3788cf4aedb5', '0x23e871d59f0f18d7c5807943f64939af3434f11a68a14d075c2d9abc1df2bed7', '0x2a5af99e33b60ee4d4d0170a6cb4dae36db542222b0d9ba67600c8ba8655030f', '0x2cb669fcbb661e09e096862af5bca35416bd77f43336cb511d157a65b2f2c374', '0x2f3764405908797ef31f423e066482fc411ea2825aeb1fafa19dc7c8ee1aff5b', '0x2f4313940a43da620965997357299d2f499e7ebac0893e1be137d7de5d9415c0', '0x2fa9f4b2bae13e751c5ea2728b8bf5d5ef61888b4f086355211bdfdca3ccd1dd', '0x31b13169886a40d72b745d68e077e5a3a254e97089089b7081a376cda39b3156', '0x34545dd8747467d2ac4b096c41e4ba8bfb433c289001f75e17d2220042fc83df', '0x3612963dec4fb8a27dd6a4f04e169413a0cd43253657b511726b7c28330924ea', '0x3626fcfc377f39e8981772ef64825953c9cb2a81303e15efadae574e5bf8fafd', '0x38820d638794b41ff194ad0a50915cb65de3e5eae30e384d41c20890ed281277', '0x3901b2d9d3149d7849f93a9e1b4d937dac7a5da61436fa51c4ea958e796ea0dd', '0x3ad95ddf53f16455691d1349edfb065f4531efda3cc4a67a882fe86c99e9ed71', '0x3b16cd2d089ff719666acfbe8a35a02c00b8e5cc9589fd6c85ed08945e73b269', '0x3b7cc5b85d1b45fb5a48f83394aa05c063b235ec87b0612a17010a534068490d', '0x3faf314955b0457483bc89c0e80140b406144540363b8ef449bbc5304f0d5d33', '0x3fbc8316ec429035a006364ebdc3d2da355b2de8ab2e633e3243d818de834148', '0x44159d391c8cb522c5574e787dde50d62721533b46770f459b4ceb54a4c8cd28', '0x45f21ac8c19f10f239ba9f2c3a34f55061824b7e36c9a5b8a3712f26b34d9b10', '0x46db9386f4a88f28dff68e3fb2a6429b93d2c19ca06b136e8c485a86a09b3c8a', '0x48aff59312ee67e1df98929f7812870dac46ee7017ce9d86dc17ac7c7bbb787c', '0x48dbb57a6c88ac3173ef531181a3bec85f73ede5fbb7406da031b5b48902a561', '0x4c1d68c153129865149ae2fc383266a58b1f72833ba3fe61c14b598a8c57e14e', '0x4ceb412960a89342a8db6bf9d848cba453b17f4d903e04a56e461da429afa2b3', '0x4def331a2e7d7b0f11eda9475ba114cc931bd7443828d2d155c3c63d5b1828e2', '0x4f2fa4979cfec1d98d7392934e42b39038f37e60f35084304fc0144c01d842d7', '0x50a4ebe2fa2636a9e4af1cc907f87175a9861ca3878574dceccebffcb03f1fd9', '0x5136c75476dcb4e688fdcfdd7cdd9e5b61f5f43303741b580ecea1de50294956', '0x516f501c699ecc0d7327d27e8968d8656557ab099f66de296aa285df9b707e55', '0x5440eaaa6bb23ad4cdb60d48a64263e577efbe9d8453c578cbc17597fa9644dd', '0x549f27523e5050766dad1cb49e0da1a92a164d9073bd23153d51463b5fe85da4', '0x54bce803c3bfed2e041c47f88531986cc392702ad2abaa914a06a9bc9dafa91a', '0x5788d08ead6d8e105ce961b264dc3a56a93e498aba5a697896a8489d6630a1df', '0x579f3891419ba52002b14a664cc019dbfad7351d44338ea0117080ddc24e62d8', '0x57b3df69283f8b07d7b25aa04c841e3a3d5748f9114f504cdc51ced710a61fb3', '0x62aa7128a49dac50dda4196e336e67f1bb1d8804d20a13f2925c8b8e962adfcf', '0x655ace2ae7a79ed759e0bc1b65c427599d7d27223cdeb5b7c70b751f2afefff3', '0x66b1bd4b23aeeff5c51e419a27f7c5f3267fef6cc98cc1820efd9a31bb100f3b', '0x66fca5794d892ec4f56acc5a2b6dfe038b753612480d35dcee88664a67b70d3e', '0x69ffaa0624e508afcd3b93f52124df5b3143cee3a08f4e1edc2b0810ca4f3d96', '0x6c3b87281191bf120e953981878cef66277414fe66eb96d4e9a6e4038fde31ee', '0x6c8e34e26f3a676367da2472301b32194a244efc1aa7962fb82a87494a164d57', '0x6d5a71bebd50681b0ed185f1bd68c04a07f2aeae802ff0af0b28d708102cbcfa', '0x6f38f45b603dc20337cc5f15cdab9f1db6d905343d7ce86eeabd3783c8371051', '0x6fd05e3efef91700536056dffa3b1b3cade667b864aaa0c830a5c6575df472a1', '0x70297cae0cd7cae38334d9205fea5b6c943a41b080205a7608935aab97e816cd', '0x72fa5ac4ecd61bdd36cb947bd6fbc291b22a11fad69283e0ad0b8f87b26777cf', '0x746b266c76d6b4fb45924b84412d906e4ecebad6395ca4a3530c5fa9b576647f', '0x75ea83bc5f1d1760292d40583df9b335a9a5cb29a511da87f6effafe62f05864', '0x763d27d9a72f005eea80ec383eaa6910bfa27a1006407187754c352517a3ee34', '0x7b123a5de0b62c11a70373b72ccfe6418fd560f2fa59f5f3be88ec00f033a073', '0x7c8d4c7b716b08d69d4576b76d851fcfc5f9efb3fdf7ae31ac28350fa680c549', '0x7e2692d04a5773abe2375aa662d8d5e0766364cd1e57b54bb62f768142e36e6c', '0x7ff6bec41a66b6e2ef8fcaaf00fe428a3c6988e2827e2b4c44d902b06e6eae7d', '0x8190552c5e6005404c31b6e22c9a3a6c7dfdfae47f8d7dc7578127060a6c8f10', '0x8394050573b750d83e0100d0cf8bcc9b1ef55eb04d8b9c88653c0d689cfbffa1', '0x857d557c9b035671443ff82adf00785410eb1fe404fbf9596f5a9707a0619391', '0x860afa3652311bc8071562456a361d570b86e59273b87ca3aef570ddfe88e82d', '0x87670df3404366686147fc36feac9c0289eff76a742c87982789738b7d299992', '0x8959726eeeeb64d0e6906c536d18e591451f0fe760470428c41f8d704c3f9466', '0x8996c42159a3e12333dda180265e7080afbf69b3cc64d4242cbe4a8a9e30b015', '0x8e448711312a2181ab27929feae4a655390000482be9603c38eba5e1b23b3ce6', '0x9163c7e56a5fd1da5527f033a3c5123a0b574e320e852d91b9c1a27c5e26a6ad', '0x95be57dff88f49d03c23522255f996494d623aaf1395784d2b32710bdedbb98e', '0x96c669b5672e88067ed3718a98bfc839b78272d095572fbcff97fcc3a361dec9', '0x970cc1c2ba974fd132068cf3464226d37e31891a055fcbb58718905c8a5ff758', '0x97c6d6c847ce58b452d0962249eff1fb734dcd1da2e6d792a83785c28ad57f78', '0x98d6a60fdfd992fdf26d28baf0d05bcb9e359a062ac669229a2b2fb2d33aad43', '0x9d597a76c54ae93882e0c67fe5d9b2622b83f554618b7431cd7c543a9c3d7494', '0x9efb7c29a325526199384cb5a486854d9d428f9264124481e0784c7bbade55ab', '0x9fcd11b4b19bad688a0b6fd96d9801caf9cc291bff5f3edfaf7772f1ddb2f586', '0x9ffb4433513738e07dfe8b122da27e0d662dba8b14db81f16f31ca8ee47ee112', '0xa0944b6937fc65d3525b40d40ded775bb3b007ba0a622ef855105e51f8538379', '0xa1b1e7b5c31a10c31d521075064e5b44e3acebd4050a44939fa5254c2d9a214b', '0xa1b649ca5ecbdf147d7379b394e33e2dc1ab488770f3e3aab5e13a91922ecb35', '0xa2ccd5357accf3ea1d5ef28a4d3346fe6e7362c6b83f0a3c028896c4e3d1bdb4', '0xa4050b19707e5a90cf946fd77611744572f41b65894f3ac20c2f2d7f15c1db78', '0xa442aea56ccbcb35044a869b0cc4785bb69de3d05241251ee72ad24cb3113504', '0xa4af5ac77f5691cbe0febee7eae78a2bf040d08a5c38290ffac1bdb27b9331e3', '0xa4f579547464d550b5fc6f9fff82092386f134a9b1b0957e7549813b23a24f0d', '0xa872f308b305f349117bda033b64b65cbb39de46cef58a94970015d1fed6ed2c', '0xa916354a0bb5502ccf517c9877ef2924b72b3ec8e5cdc33d618df5d26e616533', '0xa950a0231c0b09a3795fe9e6cec1f36fdce3df25a9f262efefe0492c63604e95', '0xa9dd6fade761912f421b88e2da464c939da5362babadaf79ae4d1078beeaf389', '0xaa730f1865d48409ef111dd002362a90dc745787a73c9c111accd5d06fdcdc70', '0xab3bcb29f8371906e61747ad977a52154e310bef28e4a3d7ac0742e59c1eb6f1', '0xac849472c4a3c5bbca30f92580f96e2971a8c98c9802651b4e3d6a0fe538f1fa', '0xaeb2b06dfa3bd5009242d46eb93dc59e8d46205ed65051ec2b10300f562ec0df', '0xaffe67c0ae77c7026e3ecd5d6554ee20c6a6b289d2965f0921c9109c0a5bd9f7', '0xb35cf78465c13bf089da34c5181798b986a3da4452337106b5db684b8efd3bba', '0xb45c80a4ee4e682a511c2e04afe3b3a1ca0eb78f0a8589aca139acfa8385fe77', '0xb4fb3532d2c386f12afb5412691d480f00669497c813a3a6d382b3f0862f7772', '0xb502a291b648c4c1a8697e11d3a2460ea13aed1203db5c721cae64ec9e32e584', '0xb522bdf16cf2c8e19f53cc23845559ceb687d45b2515aaa0071a5dc3cf9b7501', '0xb733443e76022a091531387b953a045a7977523066b9d349c472909cbe9cb7a9', '0xb8efb78bad6e0cdb4c100f0dd60a82ab6192550c05c34c870703834cce38625a', '0xb95d8e96372773981f0aabf04faace19d25ee72e5a5566cf988ff96ef3c30519', '0xbb3140eebfb29d9eaa3ec8478fbbae4b1bcf90b5ed668b7a3b5e5e62a0db199c', '0xbb9c8713e70c3ec8dc1537d78a6689ad8a664dda4f989eace56122b0705db140', '0xbe59e02d04c645f9a567e9856f67fef0b2ac9da4482b9f27f3db80a00ba72476', '0xbee3dc7b9c8495c14c5702d535927b9acb73e4fefbd99719f3305df01f256cad', '0xbee94c0e2389bc3b279fdfb8e384472173f18930785700b3f20464f476936ecb', '0xc21a8b060e4cc875c706586c4eaeb06678b5dbb1b8b14c7d272e5143c2903e85', '0xc246853f517e037a86c1f9039ea81f78df3efd195eceeac9576ba895248ee83e', '0xc31f31819a5025990e2f6c74787a2136ae805a1aae403e4a71c6798ee6e6a169', '0xc39930e9ad1180f22b7ab32a078a948fd3f19f345d03091e7c18e7a98e096bfc', '0xc422c7bb8dc3e813798846d7587daa95cee3379da9841fe0deb9c4b2f13f00eb', '0xc4e31b3b83a9ef70d9895681b501f35e87e28ffd801d5c7badfba1ddc8a5db1f', '0xc5689ad99119a5e96f03e53644605dc913e0fc8f3a184959508080017f9a807d', '0xc645a7b62d9856c35a39c8990364539ca3e1059cca15f48a7592cbd570c1132d', '0xc6ecd9f01c443c95adcafeae11d53cccb44b30f57bab1a66392ea905c9cb65f5', '0xc90dc85c9b127e4974b6ddad07b8be21743e49304fc9215017bbf152e4359cc9', '0xc9cfa5d869a5fc8b976422b3b613c99ecbac60a2d194a7ded444de6f68537bdf', '0xca18361974b8afade02d0498d5dc04a89cc5ecffd2cb55d1b96ff8f4de1fe6ee', '0xcc6231b16da77eb6a2059900b97beb24e4e8bdb2dcfa45ea80c2276fbe2c1a99', '0xcd75b91d2d18e9a9668d03fe81352a0a1dffa852985176091c6876be72cda740', '0xcdb371897683931c647fe401b351b9812b2a888d9e02c281611108979588ee66', '0xcffa57b941ac018ab0999c17682a4536847876197d0edd85919bff362966d4cb', '0xd105074a3c1e40db49afeb0c35295cd026f9e55d384cd143d116977137fccc2c', '0xd3befc243a8f20b272d178a7703d7af420c5683be66608d9ec5bf01394714f8f', '0xd4e672fdc75bfa85d17f1954d421fe6346c3e119ee2beca411d8cd8fe2c5b44d', '0xdb0c11601e299770a4966d5183099df13649e129c8d36f0f711d7a4608deafe2', '0xdb54bd1b5f4cf8206615eb9ed11bbb3bb7cc65ff93f7498dbdce094fe6fd1cae', '0xde3d6ca770b4aa4d77518ddcbaafc46858dfda983ed7fff7b13c8a83f63e6e47', '0xe4612cdf57c40c05fe4d2b65fdaa5827d5c4579d76daa1dc82d2a2a2813fb774', '0xe583817715a7dce8058770f212d8eff9718ba62d348b5218a135ffaf013c3294', '0xe92d35b2b8505f9f4d368770802db78fd381ad63b57bd931dc383809bc886f52', '0xea39a9b9292463092836fe3c05fbef7f83050ceb55d9d69ec9086714a633f0c2', '0xeccae20af66571fab0026ce3967739c0be263082aba567e03c0e4006f645dbb8', '0xefd92e7156daaf091aec99f492825e2420101b4b9dacce30d8800868bc58ba7d', '0xf0bce2656b9cca77c9fbf8b0209441a3e95d22bb99de5dd0e7709e82089b93b9', '0xf25d58e67f3970bb911b918d789ebc749bf6794a4e242db0aa7d3666ad6e4d45', '0xf418e9f2441597f96ca8ece12433e5fa7945394499fd258be99de2e779a394b9', '0xf466bc15686d3511afafe717c7caf443ee682404f0b897d25a75783ce3f8d945', '0xf48ebaa8c8ab975d65269c831bf728e67b509361b2e6848b3dbdfdde4726735a', '0xf8576f42086df681a4ac230fb8066850b963b702c372de78034073587ea609df', '0xf8f93b8b9dcb7d616c737cc9d94f8566a67f263100bf6fe02c519daa3543023b', '0xfb0f88713ac7c61c08ccda10e1bb51d8be4cc76df0f40446a5fd744d9e3576cf', '0xfe1be711b0f617592ab660388db83e9cc5f3026c416f404361f4a744bd80f115']
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*156L2V 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*1uEcvU 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*2qs5TA 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*4q1Z1j 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*5KgA1P 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*7NQ2bS 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*BCiJTJ 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*BaAvHb 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*EooLc3 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*H6JKiN 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*HKS7Bx 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*Jgmzwu 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*KwriRM 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*Pter8V 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*RETLKh 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*S1bbQ5 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*Ts57n5 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*UwNRJr 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*WqokQX 29846.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*Wy4bKk 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*XKB9K5 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*YPrMNJ 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*cPKVoR 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*dPRM2v 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*eX55R1 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*ed2Ek9 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*gUf8Lc 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*heniGe 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*i7nh2r 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*iFhFPb 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*k43a4R 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*o7Azzw 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*pQWAu5 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*qWnooT 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*qcyJ5n 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*tabRWV 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*tni4YW 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*ufSvgb 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*vqRnxc 30001.0/30000 messages received
src.mesh_analysis.tracers.waku_tracer - WARNING - Peer 16U*xLd7C9 30001.0/30000 messages received

Here we can see that 39/40 nodes received 1 extra message than expected.

Also, we see that node 16U*WqokQX missed some messages. At first glance, looks like this node can be involved in the problem.

Further analyzing the log messages, we are able to obtain two pieces of information in form of dataframes.

Every time a node receives a message, it logs a line like the following one:

NTC 2024-08-23 11:07:20.059+00:00 waku.relay received                        topics="waku node" tid=1 file=waku_node.nim:230 my_peer_id=16UWqokQX pubsubTopic=/waku/2/rs/66/0 msg_hash=0x40937c4863ac7cde6661f7c3efac79f79ee1185ac5670e8e44c178824d30d57e receivedTime=1724411240060182528 payloadSizeBytes=91022

With this information, we are able to construct the following dataframe: