write/read column to existing table for MS SQL use Python pyodbc
$10-30 CAD
Paiement à la livraison
Python pyodbc write/read column to update existing table for MS SQL
do it fast for millions rows
just create synthetic table
existing table : 2 millions rows and 2 columns
update table with 2 millions rows and 3 columns ( format : string , int, float)
Given MS SQL server
1
Data in numpy array format : string and int and float
Write python code for fast writing column/ columns to existing table ( new column or replacing existing column )
Write python code for fast reading column/columns from existing table to numpy array
2
Data in pandas array format : string and int and float
Write python code for fast writing column/ columns to existing table ( new column or replacing existing column )
Write python code for fast reading column/columns from existing table to pandas
for example for pandas
original_data = [ [90, 'qwerewr'], [78, 'adrawer'], [65, 'faweefweq'] , [34, 'qwerweq'] ]
df_original_data = [login to view URL] ( original_data , columns = ["C1", "C2"] )
# upload orginal data to SQL talbe T1
input_data = [ [ 1,0.4,'abc' ] , [ 2, 0.9, 'dfg' ] , [3, 23.6, 'sdfgdsfgsdrfstrh'] , [2, 67.89, 'fsdfsdfg'] ]
# add columns to SQL table T1
df_add_data = [login to view URL] ( input_data , columns = ["C3", "C4", 'C5'] )
Do in one day
Nº du projet : #35782701
À propos du projet
Décerné à:
Hi, I'm a python developper with good experince in SQL, I believe can help you with this task. would you share more information over chat?
4 freelances font une offre moyenne de 23 $ pour ce travail
Hi, Greetings and hoping you are doing well, i welcome you to my profile where quality and client satisfaction is the Priority. I am Expert Dominic and i hope to cooperate with you on your project . CERTIFIED EXPERT I Plus
Hello I am Python Script expert. I have just checked your proposal carefully. I have strong experience about MYSQL. I can complete your app perfectly. I will start work immediately and deliver the best result. You wi Plus