Read database pandas

from sqlalchemy import create_engine

engine = create_engine("sqlite:///data.db")

query = """
SELECT * 
  FROM weather;
"""

weather = pd.read_sql(query, engine)

Similar codes

32 votes111 views4 answers
Copy to clipboard python
Python
6 votes106 views1 answer
Install pip on windows 10 python 3.9
Python
0 vote92 views3 answers
Mechanize python fill
Python
0 vote90 views1 answer
Python to elf
Python
1 vote305 views1 answer
Check datatype python
Python
0 vote97 views1 answer
Left-align the y-tick labels | remove the current labels
Python
0 vote118 views1 answer
Odoo 12 compute documentation
Python
0 vote107 views1 answer
When do we use *range in python
Python
0 vote98 views1 answer
Data dictionary python into numpy
Python
0 vote112 views1 answer
Read all the lines as a list in a file using the readlines() function
Python