[PYTHON] [SQLAlchemy] Read data

"python x sql" I'm a beginner, so I stumbled upon reading the data.

I want to be able to breathe this much.

loadDB.py


import pandas as pd
from sqlalchemy import create_engine

df = pd.read_sql_table("table name",create_engine("mysql://root:[email protected]:3306/Database name").connect())

Completion of the table.

3306 seems to be the default port number for mysql.

port number? ??

In a computer network, a port is an endpoint for an operating system to perform data communication. (From wikipedia)

···Yes.

I wonder if I have to understand this much as a CS major ...

Recommended Posts

[SQLAlchemy] Read data
Read pandas data
[python] Read data
sqlalchemy
Read json data with python
How to read e-Stat subregion data
sqlalchemy tutorial
SQLAlchemy notes
Data handling
SQLAlchemy Pit
SQLAlchemy BaseModel
Read a character data file with numpy
Read file
How to read problem data with paiza
Read pid.h
Books on data science to read in 2020
Read Python csv data with Pandas ⇒ Graph with Matplotlib
Read table data in PDF file with Python
[Python] How to read data from CIFAR-10 and CIFAR-100
How to read time series data in PyTorch