Python Forum
Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: pymysql.err.ProgrammingError : 1064 You have an error in your SQL syntax
Post: RE: pymysql.err.ProgrammingError : 1064 You have a...

Such a silly mistake I have made Before sql_format = "INSERT INTO " + database_name + "." + l_filename + "(" + f_str + ")" I changed this to f'INSERT INTO {l_filename} ({f_str}) VALUES ({place_hold...
pradeepkumarbe General Coding Help 1 12,392 Jul-01-2019, 08:05 AM
    Thread: pymysql.err.ProgrammingError : 1064 You have an error in your SQL syntax
Post: pymysql.err.ProgrammingError : 1064 You have an er...

I tried all the possible ways to get out this error.. I still didn't understand where its going wrong, below is my code, mysql_conn = mysql_getConn('db') cur = mysql_conn.cursor() cur._defer_warnings...
pradeepkumarbe General Coding Help 1 12,392 Jul-01-2019, 06:47 AM
    Thread: Execute .sql file in python
Post: Execute .sql file in python

Hello, I am trying to execute .sql file using python, I am using pymysql. This is the code I am using to parse sql query def parse_sql(filename): data = open("./ms.sql", 'r').read() stmts ...
pradeepkumarbe General Coding Help 3 14,189 May-27-2019, 07:18 AM
    Thread: Get specific key from multiple keys in python dictionary
Post: Get specific key from multiple keys in python dict...

I have CSV like this(below is the sample) Month Seg Zone Dist SALES 2018-12 HIGH A-ZONE NY 200 2018-12 LOW A-ZONE NY 100 2018-12 MEDIUM A-ZONE NY 300 And So on.... ...
pradeepkumarbe General Coding Help 0 2,096 Mar-24-2019, 07:23 PM
    Thread: SQL select join operation in python(Select.. join)
Post: SQL select join operation in python(Select.. join)

I have data set called Account_universe ACC_ID ZIP_CODE 001AAD 638400 002ADF 638402 003AAS 638902 004AGF 123480 005AQA 987650 Next data set Alt_Account_univ ACC_ID ALT_ID SOURCE 001AAD 10000 confd 00...
pradeepkumarbe General Coding Help 1 2,204 Feb-14-2019, 05:25 PM
    Thread: Subtract rows (like r[1]-r[2] and r[3]-r[3]) and no pandas
Post: Subtract rows (like r[1]-r[2] and r[3]-r[3]) and n...

I have csv file like below Account Dates Sales ADBVC 10-dec-2018 12 ADBVC 11-Dec-2018 10 SDFC 14-Dec-2018 15 SDFC 10-Dec-2018 11 I want output like Account Dates Sales Avg ADBVC 10-dec...
pradeepkumarbe Data Science 1 2,571 Dec-18-2018, 07:11 AM
    Thread: Write specific rows from pandas dataframe to csv file
Post: RE: Write specific rows from pandas dataframe to c...

Yes I agree UUID will solve my problem, but my output should be like below here how can we avoid Iteration? Territory NoOfCustomers UniqueId D00060 10 0001ABSDFG79 D00060 ...
pradeepkumarbe Data Science 3 5,432 Oct-18-2018, 08:25 PM
    Thread: Write specific rows from pandas dataframe to csv file
Post: Write specific rows from pandas dataframe to csv f...

Below is my CSV file Territory NoOfCustomer D00060 10 D00061 20 D00065 70 D00067 90I have to create a Unique Id based on Number of NoOfCustomer like If NoOfCustomer <=50 then I ha...
pradeepkumarbe Data Science 3 5,432 Oct-18-2018, 07:48 PM

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020