Skip to content

Instantly share code, notes, and snippets.

@carlcrott
Created April 5, 2015 01:26
Show Gist options
  • Save carlcrott/9f97c15e55b5ffd222e7 to your computer and use it in GitHub Desktop.
Save carlcrott/9f97c15e55b5ffd222e7 to your computer and use it in GitHub Desktop.
meter_reading_db_df = pandas.read_sql(
(
"""select t.meter_type, reading_time, usage from meter_reading a
inner join meter m on (a.meter_id = m.meter_id)
inner join meter_type t on (m.meter_type_id = t.meter_type_id)
where meter_name in ( %(meter)s )
and version_number in (select max(version_number)
from meter_reading_version b
where a.meter_id = b.meter_id)"""),
db_engine,
params={ "meter":meter }
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment