Show HN: Chatistics – Turn Telegram, WhatsApp, Messenger Chatlogs to DataFrames
Chatistics
Python 3 scripts to convert chat logs from various messaging platforms into Panda DataFrames. Can also generate histograms and word clouds from the chat logs.
Changelog
10 Jan 2020: UPDATED ALL THE THINGS! Thanks to mar-muel and manueth, pretty much everything has been updated and improved, and WhatsApp is now supported!
21 Oct 2018: Updated Facebook Messenger and Google Hangouts parsers to make them work with the new exported file formats.
9 Feb 2018: Telegram support added thanks to bmwant.
24 Oct 2016: Initial release supporting Facebook Messenger and Google Hangouts.
Support Matrix
Platform | Direct Chat | Group Chat |
---|---|---|
Facebook Messenger | ✔ | ✘ |
Google Hangouts | ✔ | ✘ |
Telegram | ✔ | ✘ |
✔ | ✔ |
Exported data
Data exported for each message regardless of the platform:
Column | Content |
---|---|
timestamp | UNIX timestamp (in seconds) |
conversationId | A conversation ID, unique by platform |
conversationWithName | Name of the other people in a direct conversation, or name of the group conversation |
senderName | Name of the sender |
outgoing | Boolean value whether the message is outgoing/coming from owner |
text | Text of the message |
language | Language of the conversation as inferred by langdetect |
platform | Platform (see support matrix above) |
Exporting your chat logs
1. Download your chat logs
Google Hangouts
Warning: Google Hangouts archives can take a long time to be ready for download - up to one hour in our experience.
- Go to Google Takeout: https://ift.tt/1JcNRfo
- Request an archive containing your Hangouts chat logs
- Download the archive, then extract the file called
Hangouts.json
- Move it to
./raw_data/hangouts/
Facebook Messenger
Warning: Facebook archives can take a very long time to be ready for download - up to 12 hours! They can weight several gigabytes. Start with an archive containing just a few months of data if you want to quickly get started, this shouldn’t take more than a few minutes to complete.
- Go to the page “Your Facebook Information”: https://ift.tt/2xWDqjH
- Click on “Download Your Information”
- Select the date range you want. The format must be JSON. Media won’t be used, so you can set the quality to “Low” to speed things up.
- Click on “Deselect All”, then scroll down to select “Messages” only
- Click on “Create File” at the top of the list. It will take Facebook a while to generate your archive.
- Once the archive is ready, download and extract it, then move the content of the
messages
folder into./raw_data/messenger/
Unfortunately, WhatsApp only lets you export your conversations from your phone and one by one.
- On your phone, open the chat conversation you want to export
- On Android, tap on ⋮ > More > Export chat. On iOS, tap on the interlocutor’s name > Export chat
- Choose “Without Media”
- Send chat to yourself eg via Email
- Unpack the archive and add the individual .txt files to the folder
./raw_data/whatsapp/
Telegram
The Telegram API works differently: you will first need to setup Chatistics, then query your chat logs programmatically. This process is documented below. Exporting Telegram chat logs is very fast.
2. Setup Chatistics
First, install the required Python packages:
Use conda (recommended)
conda env create -f environment.yml conda activate chatistics
Or virtualenv
virtualenv chatistics source chatistics/bin/activate pip install -r requirements.txt
You can now parse the messages by using the command python parse.py
.
By default the parsers will try to infer your own name (i.e. your username) from the data. If this fails you can provide your own name to the parser by providing the --own-name
argument. The name should match your name exactly as used on that chat platform.
# Google Hangouts python parse.py hangouts # Facebook Messenger python parse.py messenger # WhatsApp python parse.py whatsapp
Telegram
- Create your Telegram application to access chat logs (instructions). You will need
api_id
andapi_hash
which we will now set as environment variables. - Run
cp secrets.sh.example secrets.sh
and fill in the values for the environment variablesTELEGRAM_API_ID
,TELEGRAMP_API_HASH
andTELEGRAM_PHONE
(your phone number including country code). - Run
source secrets.sh
- Execute the parser script using
python parse.py telegram
The pickle files will now be ready for analysis in the data
folder!
For more options use the -h
argument on the parsers (e.g. python parse.py telegram --help
).
3. All done! Play with your data
Chatistics can print the chat logs as raw text. It can also create histograms, showing how many messages each interlocutor sent, or generate word clouds based on word density and a base image.
Export
You can view the data in stdout (default) or export it to csv, json, or as a Dataframe pickle.
You can use the same filter options as described above in combination with an output format option:
-f {stdout,json,csv,pkl}, --format {stdout,json,csv,pkl} Output format (default: stdout)
Histograms
Plot all messages with:
python visualize.py breakdown
Among other options you can filter messages as needed (also see python visualize.py breakdown --help
):
--platforms {telegram,whatsapp,messenger,hangouts} Use data only from certain platforms (default: ['telegram', 'whatsapp', 'messenger', 'hangouts']) --filter-conversation Limit by conversations with this person/group (default: []) --filter-sender Limit to messages sent by this person/group (default: []) --remove-conversation Remove messages by these senders/groups (default: []) --remove-sender Remove all messages by this sender (default: []) --contains-keyword Filter by messages which contain certain keywords (default: []) --outgoing-only Limit by outgoing messages (default: False) --incoming-only Limit by incoming messages (default: False)
Eg to see all the messages sent between you and Jane Doe:
python visualize.py breakdown --filter-conversation "Jane Doe"
To see the messages sent to you by the top 10 people with whom you talk the most:
python visualize.py breakdown -n 10 --incoming-only
You can also plot the conversation densities using the --as-density
flag.
Word Cloud
You will need a mask file to render the word cloud. The white bits of the image will be left empty, the rest will be filled with words using the color of the image. See the WordCloud library documentation for more information.
python visualize.py cloud -m raw_outlines/users.jpg
You can filter which messages to use using the same flags as with histograms.
Development
Install dev environment using
conda env create -f environment_dev.yml
Run tests from project root using
Improvement ideas
- Parsers for more chat platforms: Signal? Pidgin? …
- Handle group chats on more platforms.
- See open issues for more ideas.
Pull requests are welcome!
Misc
- Word cloud generated using https://ift.tt/W2OyPI
- Stopwords from https://ift.tt/28K8DfI
- Code under MIT license
from Hacker News https://ift.tt/2tr0aZV