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

9 votes259 views2 answers
Python: remove specific values in a dataframe
Python
0 vote196 views1 answer
RuntimeError: Please set pin numbering mode using GPIO.setmode(GPIO.BOARD) or GPIO.setmode(GPIO.BCM)
Python
8 votes228 views1 answer
Check integer number python
Python
0 vote203 views1 answer
Separate array along axis
Python
24 votes213 views1 answer
Creating a new enviroment in conda
Python
1 vote195 views1 answer
How to get a list of followers on instagram python
Python
1 vote184 views2 answers
Numpy random for string
Python
6 votes204 views2 answers
Python check if folder is empty
Python
2 votes235 views3 answers
Python find first occurrence in list
Python
-1 vote195 views1 answer
Count variable in class python
Python