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
  Confused by the different ways of extracting data in DataFrame leea2024 1 639 Aug-17-2024, 01:34 PM
Last Post: deanhystad
  Python script to extract data from API to database melpys 0 814 Aug-12-2024, 05:53 PM
Last Post: melpys
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 1,332 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  Filter data into new dataframe as main dataframe is being populated cubangt 8 2,966 Oct-23-2023, 12:43 AM
Last Post: cubangt
  How to detect abnormal data in big database python vanphuht91 5 2,286 Jun-27-2023, 11:22 PM
Last Post: Skaperen
  Database that can compress a column, or all data, automatically? Calab 3 2,071 May-22-2023, 03:25 AM
Last Post: Calab
  Basic SQL query using Py: Inserting or querying sqlite3 database not returning data marlonbown 3 3,007 Nov-08-2022, 07:16 PM
Last Post: marlonbown
  Seeing al the data in a dataframe or numpy.array Led_Zeppelin 1 1,690 Jul-11-2022, 08:54 PM
Last Post: Larz60+
  Need help formatting dataframe data before saving to CSV cubangt 16 10,762 Jul-01-2022, 12:54 PM
Last Post: cubangt
  Same Data Showing Several Times With Beautifulsoup Query eddywinch82 2 1,988 May-29-2022, 11:46 PM
Last Post: eddywinch82

Forum Jump:

User Panel Messages

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