I have a large script that saves data to a postgres database. Tell me how can I get rid of [‘ and ‘]. I need the data in the storage to be saved without these characters This is how the data looks in the database Tell me how to get rid of these characters, perhaps the problem occurs after parsing
Tag: database
convert data to 1NF
I have a dataset like this name date singer language phase 1 Yes or No 02.01.20 Benjamin Smith en 1 2 Parabens 01.06.21 Rafael Galvao;Simon Murphy pt;en 2 3 Love 12.11.20 Michaela Condell en 1 4 Paz 11.07.19 Ana Perez; Eduarda Pinto es;pt 3 5 Stop 12.01.21 Michael Conway;Gabriel Lee en;en 1 6 Shalom 18.06.21 Shimon Cohen hebr 1 7
FASTAPI SQLAlchemy Creating a table during run time based on user input
The user will be providing some information such as table_x with column_x. And I’d like to create these tables in an existing database or a new database based on the user’s value. These values will be provided during run-time therefore I cannot create the Model beforehand. If anyone could provide some help, let me know! Answer I’ve managed to figure
How do I route my databases in Django based on which user is logged in?
I am making a django website and I want each user to have their own database, for example now I have 2 databases hosted on azure, and in my settings.py file I have this: I have a folder called users, and within that I have a file called Fields that includes this: So I want people to login and see
when using group_by: TypeError: incompatible index of inserted column with frame index
I have a df that I’ve read from sql: I then try and get the average of the last 5 days and add it to a new column: Which gives me the following error: Any ideas what’s going wrong here? Previously this worked and now it’s throwing an error – and I can’t seem to figure out why Answer Chain
Create a DataFrame from list in lists (Pandas)
I´m having trouble creating a dataframe on my list. The list contains four columns, but instead it says on presente one column with data: The list itself is presented in this way: I know there is something happening due to the double [], but i can´t figure it out. Can´t someone help me? Here is the code so far: Answer
How to upload data from csv to database(PostgreSQL) on python
I have a few parsers that collect data and make csv file, after collecting data I need to upload data from csv to my database(PostgreSQL) p.s.table in database is already exist and just need to append data How can I do this? I have try to use sqlalchemy, but after connection don’t know what to do Didn’t find information that
open .db-file from python script returns empty file
I want to open a .db-file from python to inspect it. I can open it from a terminal, but from a python-script it only shows an empty file, while this script does work for another .db-file. What is going on? Answer I cannot reproduce your error, are you sure the paths are right ?
Pydantic created at and updated at fields
I’m new to using Pydantic and I’m using it to set up the models for FastAPI to integrate with my postgres database. I want to make a model that has an updated_at and created_at field which store the last datetime the model was updated and the datetime the model was created. I figured created_at could be something like this: How
User-created Record Fields
I am creating a web-app w/ Flask + Flask-WTF that has CRM-like features as a project. My current database (MongoDB) structure is I have: Users who can login, People who are assigned to users, and Records who are assigned to people. People have various fields to be filled out (Name, Phone Number, Email, etc). I want Users to be able