HOW TO TUTORIAL USING: RPOSTGRESQL, SENDING DATA FROM R TO POSTGRESQL with QUERIES
This is a video to aid in 𝐒𝐄𝐍𝐃𝐈𝐍𝐆 𝐃𝐀𝐓𝐀 𝐅𝐑𝐎𝐌 𝐑 𝐭𝐨 𝐏𝐒𝐐𝐋. TURN ON NOTIFICATION 🔔
Join this channel to get access to perks:
/ @mrfugudatascience
➡ Patreon: / mrfugudatasci
➡ Buy Me A Coffee: https://www.buymeacoffee.com/mrfuguda...
➡ Github: github.com/MrFuguDataScience
➡ Twitter: @MrFuguDataSci
➡ Instagram: @mrfugudatascience
you will also create a DSN config.yml file to securely hide your credentials as well as different options available.
1.) Create Dataframe with and Send to PostgreSQL
2.) Create .CSV and Send to PostgreSQL
3. ) Query PostgreSQL
4.) Send data from PosgreSQL to R
Similar Material:
◆ Send Data to Pymongo: • HOW TO TUTORIAL: PYMONGO, SENDING DAT...
#rstudio #psql #postgresql #postgresql
