Skip to main content

air-db

air-db is a data access layer (DAL) to easily query atmospheric time series datasets from various sources. air-db does not include any database. It is required to install corresponding database to work air-db properly.

To install sample database:

from airdb import Database

Database.install_sample()

A database query can be implemented as follows:

from airdb import Database

db = Database('samp', return_type='df')

q = db.query(param=['so2', 'pm10'], city='istanbul', date=['>2010-05-10', '<2012-10-07'], month=5)

print(q)

del db  # close connection to database

and the output is:

      param      reg      city              sta                date     value
0      pm10  marmara  istanbul      çatladıkapı 2010-05-10 00:00:00  0.798218
1      pm10  marmara  istanbul      çatladıkapı 2010-05-10 01:00:00  0.946180
2      pm10  marmara  istanbul      çatladıkapı 2010-05-10 02:00:00  0.884385
3      pm10  marmara  istanbul      çatladıkapı 2010-05-10 03:00:00  0.537993
4      pm10  marmara  istanbul      çatladıkapı 2010-05-10 04:00:00  0.136689
...     ...      ...       ...              ...                 ...       ...
16123   so2  marmara  istanbul  şirinevler mthm 2012-05-31 19:00:00  0.697663
16124   so2  marmara  istanbul  şirinevler mthm 2012-05-31 20:00:00  0.615755
16125   so2  marmara  istanbul  şirinevler mthm 2012-05-31 21:00:00  0.489289
16126   so2  marmara  istanbul  şirinevler mthm 2012-05-31 22:00:00  0.385102
16127   so2  marmara  istanbul  şirinevler mthm 2012-05-31 23:00:00  0.039451

[16128 rows x 6 columns]

Metadata

Release files for air-db 0.2.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for air-db 0.2.0
File Size Uploaded
air-db-0.2.0.tar.gz 28.2 kB Details

Release files / air-db-0.2.0.tar.gz

Download URL air-db-0.2.0.tar.gz
Size 28.2 kB
Tags Source
SHA-256 checksum
How to use checksums
ca239b5a39a274c5ae3443e995cf582ef641c6f9e601370dec059abebf5028d7
BLAKE2b-256 checksum
How to use checksums
d095f56d52456d901f1b77c681db2d60f6e4539b44f2f04eb6539d3d73b5a3ff
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/4.0.2 CPython/3.10.10

Release history Release notifications | RSS feed

This release

0.2.0 This release

1 release file

0.1.9

1 release file

0.1.8

1 release file

0.1.7

1 release file

0.1.6

1 release file

0.1.5

1 release file

0.1.4

1 release file

0.1.3

1 release file

0.1.2

1 release file

0.1.1

1 release file

0.1.0

1 release file

0.0.9

1 release file

0.0.8

1 release file

0.0.7

1 release file

0.0.6

1 release file

0.0.5

2 release files

0.0.4

1 release file

0.0.3

1 release file

0.0.2

2 release files

0.0.1

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page