How to import and use csvkit in a Python script

Question

I feel like this is a silly question. I've found a python library I need to use. Specifically csvkit . I need to use this in an existing application I've created. However, all of the example usage I've been able to see is from the command line where arguments are passed like this:

in2csv ne_1033_data.xlsx > data.csv

Would I be able to import this and use it within my application? Something along the lines of:

from csvkit import in2csv
in2csv(ne_1033_data.xlsx, data.csv)

Thanks for helping me out. I'm sure I'm misunderstanding something...

Answer 1

Quoting from the csvkit manual:

import csvkit

Is what you are looking for.

After importing, I'm assuming that the command syntax and data flow are similar to that of the python csv module. Again this is based on the csvkit manual.

Answer 2

You should import convert and then use convert.xls2csv :

from csvkit import convert
inputfile = open(file.csv)
convert.xls2csv(inputfile)