Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Generate Multiple sql Files With csv inputs
Post: RE: Generate Multiple sql Files With csv inputs
(Aug-20-2021, 02:39 PM)Yoriz Wrote: Of course, I just hardcoded it so I didn't need the data frame. Quote:How can I apply the below lines to data frame? appropriate_name = ".".join((row["DB"], row[...
 vkomarag General Coding Help 13 4,260 Aug-20-2021, 07:03 PM
    Thread: Generate Multiple sql Files With csv inputs
Post: RE: Generate Multiple sql Files With csv inputs
Can I do it using data frames rather than hardcoding
 vkomarag General Coding Help 13 4,260 Aug-20-2021, 02:37 PM
    Thread: Generate Multiple sql Files With csv inputs
Post: RE: Generate Multiple sql Files With csv inputs
That's Awesome !! This is my first post in this forum and I literally felt stranded. Thanks for saving me. I will try this and let you know if it is working fine.
 vkomarag General Coding Help 13 4,260 Aug-20-2021, 02:26 PM
    Thread: Generate Multiple sql Files With csv inputs
Post: RE: Generate Multiple sql Files With csv inputs
(Aug-20-2021, 11:26 AM)deanhystad Wrote: That is the same as before. No additional information was provided. That is not data. Quote:I m sorry that is very much clear on the input, what has been w...
 vkomarag General Coding Help 13 4,260 Aug-20-2021, 02:22 PM
    Thread: Generate Multiple sql Files With csv inputs
Post: RE: Generate Multiple sql Files With csv inputs
(Aug-19-2021, 07:13 PM)deanhystad Wrote: I don't understand your question. Could you provide an example of real data? I have the data in the .csv file as below. I have attached the .csv file in the...
 vkomarag General Coding Help 13 4,260 Aug-20-2021, 03:45 AM
    Thread: Generate Multiple sql Files With csv inputs
Post: RE: Generate Multiple sql Files With csv inputs
Any response to the actual problem is appreciated.
 vkomarag General Coding Help 13 4,260 Aug-19-2021, 05:30 PM
    Thread: Generate Multiple sql Files With csv inputs
Post: RE: Generate Multiple sql Files With csv inputs
(Aug-19-2021, 01:06 AM)Larz60+ Wrote: Take a look at my SQLAlchemy tutorial, which creates a database from CSV files here: https://python-forum.io/thread-33843.html There is also a basic SQLAlchemy ...
 vkomarag General Coding Help 13 4,260 Aug-19-2021, 12:55 PM
    Thread: Generate Multiple sql Files With csv inputs
Post: RE: Generate Multiple sql Files With csv inputs
I tried this and able to work it out except one thing. The columns I need to split into rows under select statement .This would achieve my task. e.g. SELECT EMPNO, ENAME, DEPTNO ...
 vkomarag General Coding Help 13 4,260 Aug-19-2021, 12:51 PM
    Thread: Generate Multiple sql Files With csv inputs
Post: Generate Multiple sql Files With csv inputs
Hi Team, I m new to python and started working on basics but cant get through when the problem goes to next level. I have data looks like below and attached but I need to generate create statemen...
 vkomarag General Coding Help 13 4,260 Aug-19-2021, 01:04 AM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020