Questions tagged [csv]
Comma-Separated Values or Character-Separated Values (CSV) is a common "flat file database" (or spreadsheet-style) format for storing tabular data in plain text, with fields separated by a special character (comma, tab, etc). Rows are typically denoted by newline characters. Use for any delimited file formats, including tab delimited (TSV)
27,689
questions with no upvoted or accepted answers
11
votes
1
answer
2k
views
Cannot read csv file Apache Zeppelin 0.8
I am currently using Apache Zeppelin 0.8. I tried loading a csv file like this :
val df = spark.read.option("header", "true").option("inferSchema", "true").csv("/path/to/csv/name.csv")
I have also ...
- 151
11
votes
1
answer
6k
views
iconv "incomplete character or shift sequence at end of buffer" error
I imports data from another server. Then my script converts it to .txt.
.csv file which i imported: dddd-cccc bbbbbb aaaa xx List_2015_10_27.csv
iconv command:
iconv -f UCS-2 -t UTF-8 /thepath/*...
- 123
11
votes
3
answers
10k
views
Downloading/Opening .csv file using Google chrome, it changes extension of .csv file to .xls
I have an a tag in my html file that is pointed to a .csv file. Every time I click on the link it downloads the same file in .xls extension. Why?
I tried the following:
<a href="./example....
- 5,628
9
votes
1
answer
7k
views
pgadmin 4 import/export table does not work
I have made sure that the columns match the 'column to export' field in the columns tab, not null columns have data, tried in both csv and txt but all i get is a message saying:
import/export job ...
- 195
8
votes
1
answer
7k
views
07002 [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error
I am writing some simple Python code to extract data from a CSV file and send it to SQL Server database. But I am getting this 07002 COUNT field incorrect or syntax error. The CSV file has multiple ...
- 81
7
votes
0
answers
2k
views
Create a single schema dataframe when reading multiple csv files under a directory
I have thousands of CSV files that have similar but non-identical headers under a single directory. The structure is as follow:
path/to/files/unique_parent_directory/*.csv
One csv file can be:
|...
- 256
7
votes
2
answers
348
views
How to convert JSONObject to .csv in GWT?
I'm totally new to GWT, so sorry if this is a trivial question, but I can't find the answer. I'm having this already working function(s) where I can export as .xlsx one table. This is okay, it's ...
- 165
7
votes
0
answers
1k
views
Best way to convert CSV file into XLSX and provide both formats as export for user
I implemented a CSV exporter which works like the following:
User triggers CSV export
App creates a new background job
Job generates CSV using CSV.generate
Job saves file on Amazon S3 with paperclip (...
- 2,697
7
votes
0
answers
7k
views
Datatables - Add Row / Columns on export
I am looking at adding some data into the exporting csv from a datatables export button that isn't in the initial table on the view.
The table as headers looks like below with data following below in ...
- 91
7
votes
1
answer
7k
views
createReadStream end fires before data finished processing
I am trying to do the following:
Stream a csv file in line by line.
Modify the data contained in each line.
Once all lines are streamed and processed, finish and move on to next task.
The problem is ...
- 537
7
votes
2
answers
3k
views
Force Excel 2007 to default to display seconds in time data
For work, we frequently work with generated csv files which have time data as one column, and the time data is accurate to the nearest second. Opening the files in Excel 2007 (On Windows 7), the ...
7
votes
2
answers
1k
views
Error using csvsql utility in csvkit python package on Mac Yosemite
I am new to python and mysql. I am trying to use the csvsql utility within the csvkit python library on Mac OS X Yosemite to create a table in my mysql database, and to upload the data. When I try to ...
- 71
7
votes
2
answers
7k
views
Convert JSON to CSV in Scala?
Is there any already available library that can convert JSON string (most probably more than 1 rows of data) to CSV file.
I googled a lot for any such libraries in Scala, but I could find none.
What ...
- 1,159
7
votes
1
answer
4k
views
Numpy Genfromtxt slower than pandas read_csv
I'm loading a CSV file (if you want the specific file, it's the training csv from http://www.kaggle.com/c/loan-default-prediction). Loading the csv in numpy takes dramatically more time than in pandas....
- 1,321
7
votes
1
answer
3k
views
Hive CSV line delimiter configuration
When creating an external table on a CSV file using Hive,
you can either use the Hive-internal CSV Serde:
...
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
LOCATION '...'
...
- 3,218