search

capitalone / giraffez

User-friendly Teradata client for Python
https://capitalone.github.io/giraffez
Apache License 2.0
108 stars 31 forks source link

decimal value (1/tenth position) is dropped when the digit is 0 #44

Closed suvasu closed 6 years ago

suvasu commented 6 years ago

reading a decimal into a panda data frame has issues when the 1/10th digit is a zero.

import pandas as pd import giraffe slq1='select 10.01;' sql_results=giraffe.Cmd().execute(slq1) r1=sql_results.one() df1 = pd.DataFrame(r1.rows, columns=r1.columns.safe_names) print df1

0 10.1

slq2='select 10.08;' sql_results=giraffe.Cmd().execute(slq2) r1=sql_results.one() df1 = pd.DataFrame(r1.rows, columns=r1.columns.safe_names) print df1

0 10.8