|
|
|
|
|
|
by peterthehacker
1698 days ago
|
|
|
Sounds like an inexperienced data engineer. One of the first things you learn is to read tabular data into a DataFrame, like pd.read_csv. So, there’s a natural progression to pd.read_sql [0], which default behavior loads SELECT * FROM t without any filters into a DataFrame. But, it also accepts a raw sql query or SQLAlchemy selectable, which should be used to join/filter data before loading into python. [0]https://pandas.pydata.org/docs/reference/api/pandas.read_sql... |
|
|