Guest User

Untitled

a guest
Jul 19th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. def procesar_archivo(filename):
  2. """Procesar un csv para importar a la tabla"""
  3. import pandas
  4. dateparser = lambda x: pandas.datetime.strptime(x, '%d/%m/%Y')
  5. df = pandas.read_csv(filename, delimiter=";", decimal=".", parse_dates=['fecha'], date_parser=dateparser )
  6. print df
  7. df.to_sql('diario', con=g.data.getEngine(), if_exists='append', index=False)
Add Comment
Please, Sign In to add comment