Athena connector python

from pyathena import connect
from pyathena.util import as_pandas

cursor = connect(aws_access_key_id="YOUR_ACCESS_KEY_ID",
                 aws_secret_access_key="YOUR_SECRET_ACCESS_KEY",
                 s3_staging_dir="s3://YOUR_S3_BUCKET/path/to/",
                 region_name="us-west-2").cursor()
cursor.execute("SELECT * FROM many_rows")
df = as_pandas(cursor)
print(df.describe())

Source: pypi.org

Similar codes

0 vote367 views1 answer
Print("Default max_rows: {} and min_rows: {}".format( pd.get_option("max_rows"), pd.get_option("min_rows")))
Python
0 vote342 views1 answer
We want to estimate the cost of painting a property. Interior wall painting cost is Rs.18 per sq.ft. and exterior wall painting cost is Rs.12 per sq.ft.
Python
1 vote340 views2 answers
How to convert integer to binary string python
Python
1 vote342 views1 answer
Find and count unique values of a single column in Pandas DataFrame
Python
3 votes335 views2 answers
Python remove cached package
Python
2 votes325 views1 answer
Get local timezone python
Python
3 votes368 views1 answer
Remove all occurrences of a character in a list python
Python
2 votes410 views1 answer
Check if message is in dm discord.py
Python
8 votes327 views2 answers
Flask.pocoo.org quickstart
Python
0 vote345 views1 answer
Panda Python - Calculating what percentage of values are true and false out of total in boolean column
Python