HOW TO PYTHON TO MYSQL | DATE TIME | NAN VALUES | IMPORT ERRORS

HOW TO PYTHON TO MYSQL | DATE TIME | NAN VALUES | IMPORT ERRORS | TUTORIAL FOR BEGINNERS

This video goes over 𝗣𝘆𝘁𝗵𝗼𝗻 to 𝐌𝐲𝐒𝐐𝐋 using Mysql connector. You will see examples that will fail for transferring data such as 𝗯𝘂𝗹𝗸 𝗶𝗻𝘀𝗲𝗿𝘁, 𝐝𝐚𝐭𝐞 𝐭𝐢𝐦𝐞, how to handle or consider 𝗡𝗮𝗡 𝘃𝗮𝗹𝘂𝗲𝘀, as well as dot notation problems. Turn on the 🔔 notification

Join this channel to get access to perks:
https://www.youtube.com/channel/UCbni-TDI-Ub8VlGaP8HLTNw/join

Github: https://github.com/MrFuguDataScience/SendDataFrom-R-Python-to-SQL-PSQL-Mongo/blob/master/Python_MySQL_Hiccups.ipynb

➡ Patreon: https://www.patreon.com/mrfugudatasci
➡ Buy Me A Coffee: https://www.buymeacoffee.com/mrfugudatasci
➡ Github: github.com/MrFuguDataScience
➡ Twitter: @MrFuguDataSci
➡ Instagram: @mrfugudatascience

𝐀𝐦𝐚𝐳𝐨𝐧 𝐀𝐟𝐟𝐢𝐥𝐢𝐚𝐭𝐞 𝐋𝐢𝐧𝐤𝐬: (I receive a small commission on purchases)
* Prices & Availability Subject to change
——————————————–
Apple AirTag: https://amzn.to/3dNAZHM

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

𝐕𝐢𝐝𝐞𝐨𝐬 𝐘𝐨𝐮 𝐌𝐚𝐲 𝐀𝐥𝐬𝐨 𝐋𝐢𝐤𝐞:

▶️ Python Date Time: https://youtu.be/6UNIuAu_QkU

▶️ Config Files MySQL & PSQL: https://youtu.be/kIS58p9m9Io

▶️ PYTHON TO MYSQL: (MySQL.CONNECT) | CREATE CONFIG FILES | SIMPLE QUERY | DATAFRAME: https://youtu.be/9kvHZnIz_zw

▶️ SEND DATA FROM PYTHON TO MYSQL: CSV | DATAFRAME | EXPORT CSV: https://youtu.be/VnbdUQzDZo8

▶️ SENDING DATA FROM PYTHON TO POSTGRESQL with psycopg2: https://youtu.be/453c3iuIU_8

▶️ PYTHON TO POSTGESQL (Pycopg2) TRIGGER CREATION | USER DEFINED FUNCTION : https://youtu.be/GRPNb7QntUc

▶️ SENDING DATA FROM PYTHON TO POSTGRESQL with psycopg2: https://youtu.be/453c3iuIU_8

▶️ POSTGRESQL TO PYTHON (psycopg2) : EXTRACT FUNCTION CREATE FREQ TABLE | SEABORN NESTED Bar Plot: https://youtu.be/aziqE7x7BfU

▶️ SENDING DATA TO/FROM PYTHON TO MONGO | QUERIES | DATAFRAME | CSV: https://youtu.be/NGP5GsUKVog

▶️ SEND DATA FROM PYTHON TO MYSQL: CSV | DATAFRAME | EXPORT CSV: https://youtu.be/VnbdUQzDZo8

▶️ RPOSTGRESQL, SENDING DATA FROM R TO POSTGRESQL with QUERIES: https://youtu.be/ChmHbkwGTPQ

▶️ PYMONGO, SENDING DATA TO/FROM PYTHON TO MONGO | QUERIES | DATAFRAME | CSV: https://youtu.be/NGP5GsUKVog

Music: Oshóva – Tidal Dance on
Soundcloud: https://soundcloud.com/osh-va ,
youtube: https://www.youtube.com/channel/UC_uiomVq61yUos1FUuOdsTw
Music: Neffex, Ruthless

Song: North Sea, by Riot Youtube Audio Library Collection

Light/flare video overlay gif: https://pixabay.com/videos/light-fireworks-pyrotechnics-21946/

Music: Neffex, Ruthless

Thumbnail: https://pixabay.com/vectors/dive-scuba-ocean-sea-water-fish-4219524/

#mysql, #python, #mrfugudatascience,#mysqlconnector, #SQL,#database,#datascience