PyAthena is a Python DB API 2.0 (PEP 249) client for Amazon Athena.
MIT License
Bot releases are visible (Hide)
Published by github-actions[bot] over 2 years ago
Published by github-actions[bot] over 2 years ago
Published by github-actions[bot] over 2 years ago
Published by github-actions[bot] over 2 years ago
Published by github-actions[bot] almost 3 years ago
Published by github-actions[bot] almost 3 years ago
awsathena
, independent of driver notation.Published by github-actions[bot] almost 3 years ago
Published by laughingman7743 almost 3 years ago
Published by laughingman7743 over 3 years ago
Published by laughingman7743 over 3 years ago
Published by laughingman7743 over 3 years ago
Published by laughingman7743 over 3 years ago
Published by laughingman7743 almost 4 years ago
na_values
in PandasCursor from None
to empty character
.na_values
to None
in the argument of the execute method.
import pyathena
from pyathena.pandas.cursor import PandasCursor
cursor = pyathena.connect(s3_staging_dir="s3://YOUR_S3_BUCKET/path/to/",
region_name="us-west-2",
cursor_class=PandasCursor).cursor()
df = cursor.execute("SELECT * FROM many_rows",
na_values=None).as_pandas()
Thanks @EdwardJRoss. (#204)Published by laughingman7743 almost 4 years ago
na_values
in PandasCursor from None
to empty character
.na_values
to None
in the argument of the execute method.
import pyathena
from pyathena.pandas_cursor import PandasCursor
cursor = pyathena.connect(s3_staging_dir="s3://YOUR_S3_BUCKET/path/to/",
region_name="us-west-2",
cursor_class=PandasCursor).cursor()
df = cursor.execute("SELECT * FROM many_rows",
na_values=None).as_pandas()
Thanks @EdwardJRoss. (#204)Published by laughingman7743 almost 4 years ago
Published by laughingman7743 almost 4 years ago
Published by laughingman7743 almost 4 years ago
Published by laughingman7743 almost 4 years ago
Published by laughingman7743 almost 4 years ago
pyathena.pandas
.execution_time_in_millis
field from the cursor and result set object. (Same as the engine_execution_time_in_millis
field)Published by laughingman7743 about 4 years ago