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 646 Aug-17-2024, 01:34 PM
Last Post: deanhystad
  Python script to extract data from API to database melpys 0 828 Aug-12-2024, 05:53 PM
Last Post: melpys
  Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition sanky1990 0 1,344 Dec-04-2023, 09:48 PM
Last Post: sanky1990
  Filter data into new dataframe as main dataframe is being populated cubangt 8 3,008 Oct-23-2023, 12:43 AM
Last Post: cubangt
  How to detect abnormal data in big database python vanphuht91 5 2,291 Jun-27-2023, 11:22 PM
Last Post: Skaperen
  Database that can compress a column, or all data, automatically? Calab 3 2,089 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,035 Nov-08-2022, 07:16 PM
Last Post: marlonbown
  Seeing al the data in a dataframe or numpy.array Led_Zeppelin 1 1,703 Jul-11-2022, 08:54 PM
Last Post: Larz60+
  Need help formatting dataframe data before saving to CSV cubangt 16 10,797 Jul-01-2022, 12:54 PM
Last Post: cubangt
  Same Data Showing Several Times With Beautifulsoup Query eddywinch82 2 2,001 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