Stack Overflow
Stack Overflow

Questions tagged [csvkit]

Questions related to use of the cvskit utilities suite, for converting to and working with CSV format files. Check the cvskit Issues list before posting your question, in case there's a known work-around or solution.

The cvskit suite provides script-ready command-line utilities to work with the ubiquitous file format.

Supported platforms

As documented, csvkit supports the following versions of Python. Where appropriate, include these tags in your question, as well as any relevant shell tag:

It is tested on , but has been used successfully by others on both and .

References

54 questions
0
votes
0 answers

How to run csvsql in windows 7?

I am able to install csvkit, however, how to use that in Windows? I believe there are really barely people using it in Windows as my search doesn't give me a useful hint. It doesn't start in command line, nor in python shell. I remember I used it…
PasLeChoix
  • 311
  • 1
  • 5
  • 21
0
votes
1 answer

How can I import the csvsql to Python 2.7

I have successfuly installed csvkit using conda install ... However, when I try to import the libraries in Python 2.7 Spyder, I get error messages: import csvsql Traceback (most recent call last): File…
im7
  • 653
  • 2
  • 10
  • 28
0
votes
1 answer

How do I make geojson in2csv create separate columns for longitude & latitude?

in2csv -f json 'list.geojson' > 'list.csv' Generating a CSV of points from a GeoJSON file in my project using a Makefile and I'd like to have Longitude and Latitude of points explicitly. Instead I get this column as the closest thing in my…
thadk
  • 1,002
  • 1
  • 9
  • 18
0
votes
1 answer

Combining CSV's into one master CSV

Im currently playing with CSVKIT to try and combine a few csv into one master, I can get it to do two (I don't mind doing this manually for each one). But my issue runs into the following; I wanted to preserve data that matches in columns and…
Zac Grierson
  • 656
  • 1
  • 6
  • 21
0
votes
1 answer

in2csv fail on JSON

I have a small JSON file which fails to convert a data value properly. The value in question is the "id" field and the conversion produces 2016-05-06. I have a much larger file (same format) and it works properly. Any help? { "results": [ { …
DC Martin
  • 41
  • 6
0
votes
1 answer

convert bcp file to standard csv file

I am looking for any known tools or scripts which can convert my bcp files to csv files. Input bcp file format: Fields separated by 'XXXXXXX' Rows separated by 'YYYYYYY' Fields contains special characters like CRLF,CR,LF,", Tab, comma…
Bhupal.Bobbadi
  • 61
  • 1
  • 1
  • 9
0
votes
3 answers

Error while converting json to csv using csvkit

Hi i downloaded a csvkit to my macbook everything went well by following the tutorial enter link description here however when i tried to convert the json files using this command in2csv customers-page-1.json > customers-page-1.csv This is the…
Ruel Nopal
  • 385
  • 3
  • 15
-1
votes
2 answers

UnicodeEncodeError with in2csv

could you please help me with something? I have very large .xlsx files (ranging from 200MB to 1.4GB) that I need to convert to .csv format. I wanted to use a csvkit function in2csv: (venv) C:\Users\Martin\csvkit_tutorial>in2csv first.xlsx >…
Martin
  • 1
-1
votes
1 answer

Using CSV kit to add a new column to a CSV and to populate it with results from socket.gethostname()

I am trying to write a python script to parse a csv file (results.csv) that takes the hostnames listed within it looks up the IP adresses for eac hostname and appends this data to the csv file in a new column. I have done some searching and have hit…
battletux
  • 3
  • 1
1 2 3
4