sql and py

Import a csv file into a python pandas dataframe

Python – Query Pandas Dataframe for a List of Columns

Using VSCode to run a Python file with Jupyter notebook cells

Insert data into a python pandas dataframe

SQL – Update data in an SQLite table with DBeaver

Why use VSCode for Python and DBeaver for SQLite?

Import Data into Pandas Dataframe and Query It

SQL - Query Table for List of Columns

The Google Colab "california_housing_test.csv" sample data

Install Visual Studio Code

SQL - Group By

Use the MySQL Database Behind WordPress.Org to Practice SQL

Python – Query Pandas Dataframe with Row Criteria

SQL – Insert data into an SQLite table with DBeaver

Python – Check out a dataframe using dtypes, describe and info functions

Python – Delete a row of data from a python pandas dataframe

Import and Export Data between CSV and Python DataFrame, and Explore the DataFrame

Install VSCode Extensions Python and Jupyter

Python – Update a Pandas Dataframe Cell Based on Column and Row

Python – Group By

SQL – Delete a row of data from an SQLite table with DBeaver

SQL – Query Table with Row Criteria using AND and OR

SQL division to get floating-point result

Import and Export Data between CSV and SQLite Database using SQL

Why install Python directly on the Operating System instead of using a distribution like Anaconda?

2025-01-02 Install Apache Airflow on an Ubuntu Desktop 24.04 Virtual Machine

Install the boto3 python library

Connect DBeaver to SQLite and Create a Table

Install Matplotlib and Seaborn

Install python on the operating system

Import a csv file into a python pandas dataframe

2024-12-20 Row Number Partition Order By In SQL

Install Jupyter Lab

Install the Scikit-learn library

SQL – Check out columns and datatypes of an SQLite database table and PRAGMA

Why Learn SQL and Python at the Same Time?

Download and configure SQLite