Oct-16-2018, 02:26 AM
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.
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.