Pandas Tutorial (Data Analysis In Python) - Python Pandas Tutorial 14: Read Write Data From Database (read_sql, to_sql)

Pandas' read_sql, read_sql_table, read_sql_query methods provide a way to read records in database directly into a dataframe. to_sql on dataframe can be used to write dataframe records into sql table. Using sqlalchemy engine, one can interface easily with mysql, postgres, oracle databases. Topics that are covered in this Python Pandas Video: 0:00 Introduction 0:53 Create sqlalchemy engine by using create_engine() method 2:16 Read table in data frame by using read_sql_table() method 4:18 Use read_sql_query() method to execute sql query 6:44 Rename the dataframe columns using rename() 8:00 Use to_sql() method write into sql table 10:30 Use read_sql() method Code link: https://github.com/codebasics/py/blob/master/pandas/21_sql/pandas_sql.ipynb To download csv and code for all tutorials: go to https://github.com/codebasics/py, click on a green button to clone or download the entire repository and then go to relevant folder to get access to that specific file. Do you want to learn technology from me? Check https://codebasics.io/ for my affordable video courses. Next Video: Pandas Time Series Analysis Part 1: DatetimeIndex and Resample: https://www.youtube.com/watch?v=r0s4slGHwzE&list=PLeo1K3hjS3uuASpe-1LjfG5f14Bnozjwy&index=15 Popular Playlist: Complete python course: https://www.youtube.com/playlist?list=PLeo1K3hjS3uv5U-Lmlnucd7gqF-3ehIh0 Data science course: https://www.youtube.com/playlist?list=PLeo1K3hjS3us_ELKYSj_Fth2tIEkdKXvV Machine learning tutorials: https://www.youtube.com/playlist?list=PLeo1K3hjS3uvCeTYTeyfe0-rN5r8zn9rw Pandas tutorials: https://www.youtube.com/playlist?list=PLeo1K3hjS3uuASpe-1LjfG5f14Bnozjwy Git github tutorials: https://www.youtube.com/playlist?list=PLeo1K3hjS3usJuxZZUBdjAcilgfQHkRzW Matplotlib course: https://www.youtube.com/playlist?list=PLeo1K3hjS3uu4Lr8_kro2AqaO6CFYgKOl Data structures course: https://www.youtube.com/playlist?list=PLeo1K3hjS3uu_n_a__MI_KktGTLYopZ12 Website: https://codebasics.io/ Facebook: https://www.facebook.com/codebasicshub Twitter: https://twitter.com/codebasicshub