How to modify and save a column in the sqlite3 database using python? - Printable Version +- Python Forum (https://python-forum.io) +-- Forum: Python Coding (https://python-forum.io/forum-7.html) +--- Forum: Data Science (https://python-forum.io/forum-44.html) +--- Thread: How to modify and save a column in the sqlite3 database using python? (/thread-14746.html) |
How to modify and save a column in the sqlite3 database using python? - laithsky1 - Dec-15-2018 I have a CSV file (A.csv) has many columns. The question is how to modify and save a column in this file and database (data.db). I would like to replace the value 1 in column y based on the previous value: The expected answer should be :
import csv import numpy as np import numpy import pandas as pd conn = sqlite3.connect('data.db') conn.text_factory = str cur = conn.cursor() A = cur.execute("SELECT * FROM CH1_data") data = cur.execute('UPDATE CH2_data t1 SET y = (SELECT t2.y FROM CH2_data t2 WHERE t2.d < t1.d AND t2.y <> 1 ORDER BY t2.d DESC LIMIT 1) WHERE y = "" ') conn.commit() with open('output_data1001.csv', 'w') as f: writer = csv.writer(f) writer.writerow(['d', 'x','y','z']) writer.writerows(A)It does not work. Please help me....... RE: How to modify and save a column in the sqlite3 database using python? - laithsky1 - Dec-15-2018 any help guys?! RE: How to modify and save a column in the sqlite3 database using python? - buran - Dec-15-2018 cross-posted on SO RE: How to modify and save a column in the sqlite3 database using python? - micseydel - Dec-18-2018 Your question is very very jumbled. The root of it is (as was mentioned on SO) that your SQL syntax is wrong - you probably need to learn SQL. You should remove Python from the equation and just use a shell to interact with the database until you're comfortable with it, then you can add the additional complexity of Python. |