Re: [sqlalchemy] Regarding Data type consideration

2019-08-18 Thread waleed saud
I think Mohan means the header row like CSV which indicate the column name and when he say the second row he means the the row that the real data start which is the second row . correct me here Mohan if I am wrong ? https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.ht

Re: [sqlalchemy] Regarding Data type consideration

2019-08-18 Thread Mike Bayer
I've reached out on Twitter to see if I can attract more Pandas users to this list as this is a pandas-specific issue for which I don't have the expertise to answer. On Sun, Aug 18, 2019, at 5:24 AM, Mohan Raj wrote: > Hi, > > I used "sqlalchemy" in my python code for inserting a Dataframe fro

[sqlalchemy] Regarding Data type consideration

2019-08-18 Thread Mohan Raj
Hi, I used "sqlalchemy" in my python code for inserting a Dataframe from Pandas(0.25.0) to Microsoft SQL Server 2014. While inserting the data, all the columns are considered as varchar type, instead there are integer values in the column. I need to consider the data type based on second row o