HOW TO QUERY NESTED JSON: USING PYTHON TO POSTGRESQL with (psycopg2)
This video will used highly nested tweets, where we will use a function to send 𝐧𝐞𝐬𝐭𝐞𝐝 𝐣𝐬𝐨𝐧 to 𝐩𝐬𝐪𝐥 𝐟𝐫𝐨𝐦 𝐩𝐲𝐭𝐡𝐨𝐧. Then run a few queries to see how it works with json. lastly, use the nested json in our queries and end with possible ways you can further my work. Turn on the 🔔 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
Code For This Video: https://github.com/MrFuguDataScience/...
also in the sending data folder too.
𝐀𝐦𝐚𝐳𝐨𝐧 𝐀𝐟𝐟𝐢𝐥𝐢𝐚𝐭𝐞 𝐋𝐢𝐧𝐤𝐬: (I receive a small commission on purchases)
Prices & Availability Subject to change
--------------------------------------------
30 Free Trial Amazon Prime: https://amzn.to/3RhCKf9 (End Date: Dec 31, 2022 at 10:59 PM PST)
Prime Student 6 Month Free Trial: https://amzn.to/3wgMXQz (End Date: On going)
Audible Gift Membership: https://amzn.to/3pAfw7W (End Date: On Going)
Try Audible: https://amzn.to/3PETRWS (End Date: On Going)
Apple Certified Type C Charger & USB Wall Charger 20W with 2 cables: https://amzn.to/3dMdqPA
𝐕𝐢𝐝𝐞𝐨𝐬 𝐘𝐨𝐮 𝐌𝐚𝐲 𝐀𝐥𝐬𝐨 𝐋𝐢𝐤𝐞:
▶️ PARSING EXTREMELY NESTED JSON: USING PYTHON | RECURSION: • PARSING EXTREMELY NESTED JSON: USING...
▶️ CREATE NESTED (JSON) DICTIONARY: PYTHON, with pitfalls: • HOW TO CREATE NESTED JSON DICTIONARY:...
▶️ CONVERT NESTED JSON TO DATA FRAME WITH PYTHON CREATE FUNCTION TO STORE NESTED, UN-NESTED DATA: • HOW TO CONVERT NESTED JSON TO DATA FR...
▶️ REGULAR EXPRESSIONS (Regex) for Parsing ADDRESSES using Python: • HOW TO TUTORIAL: REGULAR EXPRESSIONS ...
Picture for thumbnail : https://pixabay.com/photos/frightened...
Erika Wittlieb is the artist
Picture in video: Tilgenerpictures on Instagram
Music &. Intro Pic: Special Thanks
Pixabay: instagram (subscribe gif): @imotivationitas
Music: Oshóva - Tidal Dance on
Soundcloud: / osh-va ,
youtube: / @oshova9190
#nestedjson, #psycopg #mrfugudatascience #psql #postgres #posgresql #psycopg2 #codingbasics #python3 #pythontutorialforbeginners #pythontutorial #json #parsejson #dataanalytics
