I'm adding data to a MySQL 8 database on PythonAnywhere. I'm doing this via a python 3.10 script run in VSCode using an SSH Tunnel. When I add the data it takes approximately 50 seconds to add 275 rows, data…
I specifically commented out all the code leaving only one initial handler for the start command When I start the bot I see in the logs that the bot started correctly and there is no error, but at the same…
I have a bunch of data saved as json strings in Pandas DataFrame. I'd like to aggregate the DataFrame based on json data. Here's some sample data: data = { 'id': [1, 2, 3], 'name': ['geo1', 'geo2', 'geo3'], 'json_data': […
I have a Pandas DataFrame with JSON data. I'd like to extract the most recent year and the corresponding val and add them in as new column. Sample DataFrame: data = { 'id': [1, 2, 3], 'name': ['Alice', 'Bob', 'Charlie'],…
I'm trying to create a json file in below format. However, I'm unable to remove the last comma just before "]" fl = open('fri.txt', 'r') fw = open('test.txt', 'w') lines=fl.readlines() lines = [x.strip() for x in lines] #print(lines) #print(type(lines)) month…
I'm transitioning from Spyder to VS Code, and I'm having an issue executing ad-hoc code on an interactive session. I first save this to a tmp1.py and run the selection on an interactive window: import pandas as pd df =…
I am currently working on a script to create orders to shopify. I have not included any tax lines in the json , because I want the tax to be automatically calculated using Avalara. Our Shopify is basically configured to…
I'm trying to use the numpy library in my Python project, but I'm getting an ImportError: No module named 'numpy' I've installed numpy using pip, so I'm not sure why this is happening. Here's what I've tried so far: I…
I have tried sending message to a telegram channel using Telegram's BOT API with Python 3.11.0. At first I have tried making the channel Public and the code worked fine: import requests # Replace YOUR_BOT_TOKEN with your actual bot token…
I am setting up pip using the official documentation on an Ubuntu 22.04 LTS system, and when I execute the python get-pip.py command, I get an error message stating: python3: can't open file '/home/usr/get-pip.py': [Errno 2] No such file or…