hackersandslackers/pandas-sqlalchemy-tutorial

:panda_face: :computer: Load or insert data into a SQL database using Pandas DataFrames.

Pandas SQLAlchemy Tutorial

Easily drop data into Pandas from a SQL database, or upload your DataFrames to a SQL table. Tutorial found here: https://hackersandslackers.com/connecting-pandas-to-a-sql-database-with-sqlalchemy/

Installation

Installation via requirements.txt:

$ git clone https://github.com/hackersandslackers/pandas-sqlalchemy-tutorial.git
$ cd pandas-sqlalchemy-tutorial
$ python3 -m venv myenv
$ source myenv/bin/activate
$ pip3 install -r requirements.txt
$ python3 main.py

Installation via Pipenv:

$ git clone https://github.com/hackersandslackers/pandas-sqlalchemy-tutorial.git
$ cd pandas-sqlalchemy-tutorial
$ pipenv shell
$ pipenv update
$ python3 main.py

Installation via Poetry:

$ git clone https://github.com/hackersandslackers/pandas-sqlalchemy-tutorial.git
$ cd pandas-sqlalchemy-tutorial
$ poetry shell
$ poetry update
$ poetry run

Usage

Replace the values in .env.example with your values and rename this file to .env:

• SQLALCHEMY_DATABASE_URI: Connection URI of a SQL database.

Remember never to commit secrets saved in .env files to Github.

---

Hackers and Slackers tutorials are free of charge. If you found this tutorial helpful, a small donation would be greatly appreciated to keep us in business. All proceeds go towards coffee, and all coffee goes towards more content.

pandas-sqlalchemy-tutorial's Issues

Not Null

Hello,
How can I assign not null property to my columns like assigning a data type?
Thanks in advance!

Dependabot couldn't authenticate with https://pypi.org/simple/

Dependabot couldn't authenticate with https://pypi.org/simple/.

You can provide authentication details in your Dependabot dashboard by clicking into the account menu (in the top right) and selecting 'Config variables'.

View the update logs.

Dependency Dashboard

This issue lists Renovate updates and detected dependencies. Read the Dependency Dashboard docs to learn more.

Rate-Limited

These updates are currently rate-limited. Click on a checkbox below to force their creation now.

• Update dependency pandas to v1.5.3
• Update dependency pymysql to v0.10.1
• Update dependency python-dotenv to v0.21.1
• Update dependency sqlalchemy to v1.4.52
• Update dependency SQLAlchemy to v2
• Update dependency attrs to v23
• Update dependency mock to v5
• Update dependency mock to v5
• Update dependency more-itertools to v10
• Update dependency packaging to v24
• Update dependency pandas to v2
• Update dependency pandas to v2
• Update dependency pluggy to v1
• Update dependency pymysql to v1
• Update dependency pyparsing to v3
• Update dependency pytest to v8
• Update dependency pytest to v8
• Update dependency python-dotenv to v1
• Update dependency python-dotenv to v1
• Update dependency pytz to v2024
• Update dependency sqlalchemy to v2
• 🔐 Create all rate-limited PRs at once 🔐

Edited/Blocked

These updates have been manually edited so Renovate will no longer make changes. To discard all commits and start over, click on a checkbox.

• Update dependency mock to v4.0.3
• Update dependency packaging to v20.9
• Update dependency python-dateutil to v2.9.0.post0
• Update dependency PyMySQL to v1

Open

These updates have all been created already. Click a checkbox below to force a retry/rebase of any.

• Update dependency mock to v4.0.3
• Update dependency wcwidth to v0.2.13
• Update dependency SQLAlchemy to v1.4.52
• Update dependency more-itertools to v8.14.0
• Update dependency numpy to v1.26.4
• Update dependency python-dotenv to v0.21.1
• Click on this checkbox to rebase all open PRs at once

Detected dependencies

pep621

pyproject.toml

• poetry >=0.12

pip_requirements

requirements.txt

• attrs ==19.3.0
• mock ==4.0.2
• more-itertools ==8.3.0
• numpy ==1.22.0
• packaging ==20.4
• pandas ==1.5.3
• pluggy ==0.13.1
• py ==1.11.0
• PyMySQL ==0.10.1
• pyparsing ==2.4.7
• pytest ==5.4.3
• python-dateutil ==2.8.1
• python-dotenv ==0.13.0
• pytz ==2020.5
• six ==1.16.0
• SQLAlchemy ==1.3.20
• wcwidth ==0.2.4

pipenv

Pipfile

poetry

pyproject.toml

• python ^3.8
• pandas *
• sqlalchemy *
• pymysql *
• python-dotenv *
• pytest *
• mock *

---

• Check this box to trigger a request for Renovate to run again on this repository

Test issue