Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: Fastest Method for Querying SQL Server with Python Pandas
Post: RE: Fastest Method for Querying SQL Server with Py...
(Jul-31-2020, 06:00 PM)Gribouillis Wrote: BuJayBelvin Wrote:Are you expecting it to be faster?Yes. In fact I'm a complete begginner in pandas but I read that pandas uses sqlalchemy and I have some b...
 BuJayBelvin General Coding Help 7 7,029 Aug-01-2020, 02:06 PM
    Thread: Fastest Method for Querying SQL Server with Python Pandas
Post: RE: Fastest Method for Querying SQL Server with Py...
(Jul-31-2020, 08:27 AM)Gribouillis Wrote: Have you tried to read the table through the DB-API instead of pandas for comparison? I haven't. I will see what I can find based on that suggestion. Are ...
 BuJayBelvin General Coding Help 7 7,029 Jul-31-2020, 04:57 PM
    Thread: Fastest Method for Querying SQL Server with Python Pandas
Post: Fastest Method for Querying SQL Server with Python...
I am querying a sql table with about 3.5 MM rows and 400 columns - I am estimating it is less than 5 GB in size. If I use pd.read_sql to select * from this table, it takes many, many hours to execute...
 BuJayBelvin General Coding Help 7 7,029 Jul-30-2020, 04:02 PM
    Thread: Python for excel
Post: RE: Python for excel
(Jun-27-2020, 02:41 PM)Yoriz Wrote: https://www.python-excel.org/ https://www.excelpython.org/ https://groups.google.com/forum/#!topic/...ipX5yc-gHw Thanks! This is getting much closer! Very much a...
 BuJayBelvin General Coding Help 7 123,183 Jun-27-2020, 02:57 PM
    Thread: Python for excel
Post: RE: Python for excel
Actually - after reading the snippsat post, it isn't what I am looking for exactly. I am specifically interested in manipulating excel via Python....I understand how to do these things in Pandas (or ...
 BuJayBelvin General Coding Help 7 123,183 Jun-27-2020, 02:34 PM
    Thread: Python for excel
Post: RE: Python for excel
(Jun-27-2020, 09:25 AM)snippsat Wrote: BuJayBelvin - Wrote:Not sure it exists. (I have read the openpyxl documentation.)openpyxl is okay,but i find Pandas easy and more powerful to work with. If use...
 BuJayBelvin General Coding Help 7 123,183 Jun-27-2020, 01:09 PM
    Thread: Python for excel
Post: RE: Python for excel
Thanks! It appears some of those will be helpful. My preference is to find a textbook focused on excel via python but I am finding it might be too specific of a task for an entire textbook. Thanks ...
 BuJayBelvin General Coding Help 7 123,183 Jun-27-2020, 02:21 AM
    Thread: Python for excel
Post: Python for excel
Can anyone share a reference text specifically geared towards excel users? Not sure it exists. (I have read the openpyxl documentation.) Thanks!
 BuJayBelvin General Coding Help 7 123,183 Jun-27-2020, 12:40 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