Generate table schema inspecting Excel(CSV) and import data

Posted by Frank Malina on Stack Overflow See other posts from Stack Overflow or by Frank Malina
Published on 2010-06-18T13:40:38Z Indexed on 2010/06/18 13:43 UTC
Read the original article Hit count: 212

Filed under:
|
|
|
|

How would I go around creating a MYSQL table schema inspecting an Excel(or CSV) file. Are there any ready Python libraries for the task?

Column headers would be sanitized to column names. Datatype would be estimated based on the contents of the spreadsheet column. When done, data would be loaded to the table.

I have an Excel file of ~200 columns that I want to start normalizing.

© Stack Overflow or respective owner

Related posts about python

Related posts about mysql