# Finding certain messages in your WhatsApp message is sometimes hard, but Pandas makes it easier. Doesn't require root access!
#### Tested against Google Pixel 6 / Windows 10 / Python 3.10
```python
pip install whats2df
# This is the updated version of https://github.com/hansalemaos/a_pandas_ex_whatsapp_to_df
```
## Follow these steps if you want to avoid rooting your cell phone:
* Open WhatsApp on your Android device.
* Tap the three-dot overflow menu button and navigate to "Settings > Chats > Chat backup".
* Tap End-to-end encrypted backup, then tap "Turn on".
* Create a 64-digit key and save it! You will need it! DON'T CREATE a password!
* Tap Create and wait for WhatsApp to create an encrypted backup.
* Copy the backup from your Android device to your computer (File path on my device: storage/emulated/0/Android/media/com.whatsapp/WhatsApp/Databases/msgstore.db.crypt15 - You can localize the file using https://pypi.org/project/a-pandas-ex-adb-to-df )
## Function - Python
```python
from whats2df import convert_whatsapp2pandas
convert_whatsapp2pandas(
decryptkey="e2c412cea3b0a662e47a2062fffa0db7cf7cca093636abf5bca6e701a6fae3bc",
encrypted_db=r"C:\Users\hansc\Desktop\msgstore.db.crypt15",
decrypted_db=r"C:\Users\hansc\Desktop\msgstore.db", # doesn't exist yet
output_df=r"C:\Users\hansc\Desktop\msgstore.plk", # doesn't exist yet
download_sql_dll = True, # downloads "https://www.sqlite.org/2023/sqlite-dll-win64-x64-3420000.zip" and extracts it to ./DLLs
)
```
## CLI
```
# adjust the path to "whats2df.py"
python C:\ProgramData\anaconda3\envs\nu\Lib\site-packages\whats2df\whats2df.py --decryptkey e2c412cea3b0a662e47a2062fffa0db7cf7cca093636abf5bca6e701a6fae3bc --encrypted_db C:\Users\hansc\Desktop\msgstore.db.crypt15 --decrypted_db C:\Users\hansc\Desktop\msgstore.db --output_df C:\Users\hansc\Desktop\msgstore.pkl --download_sql_dll 1
```
Raw data
{
"_id": null,
"home_page": "https://github.com/hansalemaos/whats2df",
"name": "whats2df",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "whatsapp,pandas,DataFrame,convert",
"author": "Johannes Fischer",
"author_email": "aulasparticularesdealemaosp@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/f2/6d/2b23079f0ce6f39b41839459f55087ac88d5667beb4c041717cd88667253/whats2df-0.10.tar.gz",
"platform": null,
"description": "\r\n# Finding certain messages in your WhatsApp message is sometimes hard, but Pandas makes it easier. Doesn't require root access!\r\n\r\n#### Tested against Google Pixel 6 / Windows 10 / Python 3.10\r\n\r\n```python\r\npip install whats2df\r\n\r\n# This is the updated version of https://github.com/hansalemaos/a_pandas_ex_whatsapp_to_df\r\n```\r\n\r\n## Follow these steps if you want to avoid rooting your cell phone:\r\n\r\n* Open WhatsApp on your Android device.\r\n* Tap the three-dot overflow menu button and navigate to \"Settings > Chats > Chat backup\".\r\n* Tap End-to-end encrypted backup, then tap \"Turn on\".\r\n* Create a 64-digit key and save it! You will need it! DON'T CREATE a password!\r\n* Tap Create and wait for WhatsApp to create an encrypted backup.\r\n* Copy the backup from your Android device to your computer (File path on my device: storage/emulated/0/Android/media/com.whatsapp/WhatsApp/Databases/msgstore.db.crypt15 - You can localize the file using https://pypi.org/project/a-pandas-ex-adb-to-df )\r\n\r\n\r\n## Function - Python \r\n\r\n```python\r\nfrom whats2df import convert_whatsapp2pandas\r\n\r\nconvert_whatsapp2pandas(\r\n decryptkey=\"e2c412cea3b0a662e47a2062fffa0db7cf7cca093636abf5bca6e701a6fae3bc\",\r\n encrypted_db=r\"C:\\Users\\hansc\\Desktop\\msgstore.db.crypt15\",\r\n decrypted_db=r\"C:\\Users\\hansc\\Desktop\\msgstore.db\", # doesn't exist yet\r\n output_df=r\"C:\\Users\\hansc\\Desktop\\msgstore.plk\", # doesn't exist yet\r\n download_sql_dll = True, # downloads \"https://www.sqlite.org/2023/sqlite-dll-win64-x64-3420000.zip\" and extracts it to ./DLLs\r\n)\r\n```\r\n\r\n## CLI \r\n\r\n```\r\n# adjust the path to \"whats2df.py\"\r\n\r\npython C:\\ProgramData\\anaconda3\\envs\\nu\\Lib\\site-packages\\whats2df\\whats2df.py --decryptkey e2c412cea3b0a662e47a2062fffa0db7cf7cca093636abf5bca6e701a6fae3bc --encrypted_db C:\\Users\\hansc\\Desktop\\msgstore.db.crypt15 --decrypted_db C:\\Users\\hansc\\Desktop\\msgstore.db --output_df C:\\Users\\hansc\\Desktop\\msgstore.pkl --download_sql_dll 1\r\n```\r\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Whatsapp to Pandas DataFrame (csv/xlsx/pkl) Doesn't require root access!",
"version": "0.10",
"project_urls": {
"Homepage": "https://github.com/hansalemaos/whats2df"
},
"split_keywords": [
"whatsapp",
"pandas",
"dataframe",
"convert"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "daebd1d74a58733cedb728dd0b3abd2c057d922e8356ea38662efa5f86a3b81f",
"md5": "165fe68215acbbb4c598f11bdd448ebc",
"sha256": "dc8f06c704ac35397fdc300131aa78bfc0c706e1a7259c9b87a801119425f241"
},
"downloads": -1,
"filename": "whats2df-0.10-py3-none-any.whl",
"has_sig": false,
"md5_digest": "165fe68215acbbb4c598f11bdd448ebc",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 23190,
"upload_time": "2023-06-06T17:47:00",
"upload_time_iso_8601": "2023-06-06T17:47:00.061204Z",
"url": "https://files.pythonhosted.org/packages/da/eb/d1d74a58733cedb728dd0b3abd2c057d922e8356ea38662efa5f86a3b81f/whats2df-0.10-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "f26d2b23079f0ce6f39b41839459f55087ac88d5667beb4c041717cd88667253",
"md5": "b12314cd6e7a2e665c5a22c77a4af520",
"sha256": "5ed27755545f81906fe2e15c545eb1d5281dbb000fafcd80ae9feff487d4db68"
},
"downloads": -1,
"filename": "whats2df-0.10.tar.gz",
"has_sig": false,
"md5_digest": "b12314cd6e7a2e665c5a22c77a4af520",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 22427,
"upload_time": "2023-06-06T17:47:02",
"upload_time_iso_8601": "2023-06-06T17:47:02.283328Z",
"url": "https://files.pythonhosted.org/packages/f2/6d/2b23079f0ce6f39b41839459f55087ac88d5667beb4c041717cd88667253/whats2df-0.10.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-06-06 17:47:02",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "hansalemaos",
"github_project": "whats2df",
"travis_ci": false,
"coveralls": false,
"github_actions": false,
"requirements": [],
"lcname": "whats2df"
}
JSON
