Untitled

From Eratic Motmot, 1 Year ago, written in Plain Text, viewed 315 times.
URL http://codebin.org/view/8c5bce00 Embed
Download Paste or View Raw
  1. #!/usr/bin/python
  2. import sys
  3.  
  4. import getopt
  5. from datetime import datetime
  6.  
  7. import pandas as pd
  8.  
  9. from sqlalchemy import create_engine
  10.  
  11. if __name__ == '__main__':
  12.  
  13.     # укажите входные параметры в строках
  14.     unixOptions = "sdt:edt:"  # ваш код
  15.     gnuOptions = ["start_dt=", "end_dt="]  # ваш код
  16.  
  17.     fullCmdArguments = sys.argv
  18.     argumentList = fullCmdArguments[1:]
  19.  
  20.     try:
  21.         arguments, values = getopt.getopt(
  22.             argumentList, unixOptions, gnuOptions
  23.         )
  24.     except getopt.error as err:
  25.         print(str(err))
  26.         sys.exit(2)
  27.  
  28.     start_dt = '1981-01-01'
  29.     end_dt = '1998-01-01'
  30.     for currentArgument, currentValue in arguments:
  31.         if currentArgument in ('-sdt', '--start_dt'):
  32.             start_dt = currentValue
  33.         elif currentArgument in ('-edt', '--end_dt'):
  34.             end_dt = currentValue
  35.  
  36.     db_config = {
  37.         'user': 'my_user',
  38.         'pwd': 'my_user_password',
  39.         'host': 'localhost',
  40.         'port': 5432,
  41.         'db': 'games',
  42.     }
  43.     connection_string = 'postgresql://{}:{}@{}:{}/{}'.format(
  44.         db_config['user'],
  45.         db_config['pwd'],
  46.         db_config['host'],
  47.         db_config['port'],
  48.         db_config['db'],
  49.     )
  50.  
  51.     engine = create_engine(connection_string)
  52.  
  53.     query = ''' SELECT *
  54.                 FROM data_raw
  55.                 WHERE year_of_release::TIMESTAMP BETWEEN '{}'::TIMESTAMP AND '{}'::TIMESTAMP
  56.             '''.format(start_dt, end_dt
  57.     )  # напишите код
  58.  
  59.     data_raw = pd.io.sql.read_sql(query, con=engine, index_col='game_id')
  60.     print(data_raw['year_of_release'].unique())  # ваш код

Reply to "Untitled"

Here you can reply to the paste above