Top "Csv" questions

Comma-Separated Values or Character-Separated Values (CSV) is a standard "flat file database" format for storing tabular data in plain text, consisting of an optional header row that lists the table fields delimited by commas or tabs or other delimiter character, followed by one or more rows (newline separated) representing the table records as delimited lists of the values.

Ruby on Rails - Import Data from a CSV file

I would like to import data from a CSV file into an existing database table. I do not want to …

ruby-on-rails csv import
Excel CSV - Number cell format

I produce a report as an CSV file. When I try to open the file in Excel, it makes an …

excel csv formatting number-formatting
CSV API for Java

Can anyone recommend a simple API that will allow me to use read a CSV input file, do some simple …

java csv
Skip rows during csv import pandas

I'm trying to import a .csv file using pandas.read_csv(), however I don't want to import the 2nd row …

python csv pandas
TypeError: a bytes-like object is required, not 'str' in python and CSV

TypeError: a bytes-like object is required, not 'str' getting above error while Executing below python code to save the HTML …

python python-3.x csv beautifulsoup html-table
Export table to file with column headers (column names) using the bcp utility and SQL Server 2008

I have seen a number of hacks to try to get the bcp utility to export column names along with …

sql-server csv header bcp
How to export a Hive table into a CSV file?

I used this Hive query to export a table into a CSV file. INSERT OVERWRITE DIRECTORY '/user/data/output/…

csv hive
Create Pandas DataFrame from a string

In order to test some functionality I would like to create a DataFrame from a string. Let's say my test …

python string pandas csv csv-import
Replace whitespace with a comma in a text file in Linux

I need to edit a few text files (an output from sar) and convert them into CSV files. I need …

linux shell csv sed awk
Read CSV with Scanner()

My csv is getting read into the System.out, but I've noticed that any text with a space gets moved …

java csv java.util.scanner