Python Forum
Dataframe Data Query Database
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Dataframe Data Query Database
#1
I am new to python and could not find an answer online to my question.

Essentially, I work with two seperate database types/environments and I was able to read a query into a dataframe, but I wanted to know if I can or what is best practice to use what is in the dataframe from db1 to query db2 and return a couple columns to add to my dataframe.

I was think a custom function might work, but wanted to know if there was a better way to go about it.

Thanks, appreciate any help.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 723 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  Filter data into new dataframe as main dataframe is being populated cubangt 8 989 Oct-23-2023, 12:43 AM
Last Post: cubangt
  How to detect abnormal data in big database python vanphuht91 5 1,122 Jun-27-2023, 11:22 PM
Last Post: Skaperen
  Database that can compress a column, or all data, automatically? Calab 3 1,158 May-22-2023, 03:25 AM
Last Post: Calab
  Basic SQL query using Py: Inserting or querying sqlite3 database not returning data marlonbown 3 1,351 Nov-08-2022, 07:16 PM
Last Post: marlonbown
  Seeing al the data in a dataframe or numpy.array Led_Zeppelin 1 1,137 Jul-11-2022, 08:54 PM
Last Post: Larz60+
  Need help formatting dataframe data before saving to CSV cubangt 16 5,745 Jul-01-2022, 12:54 PM
Last Post: cubangt
  Same Data Showing Several Times With Beautifulsoup Query eddywinch82 2 1,230 May-29-2022, 11:46 PM
Last Post: eddywinch82
  Query in sqlite database frewil 2 1,526 Feb-06-2022, 05:35 PM
Last Post: frewil
  I need help parsing through data and creating a database using beautiful soup username369 1 1,703 Sep-22-2021, 08:45 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

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