IT Nursery > News > csv

csv

Programming, r

IT Nursery

Prevent row names to be written to file when using write.csv

Commands: t <- data.frame(v = 5:1, v2 = 9:5) write.csv(t, "t.csv") Resulting file: # "","v","v2" # "1",5,9 # "2",4,8 # "3",3,7 # "4",2,6 ...

June 4, 2022
0 Comments

Programming, Python

IT Nursery

csv.Error: iterator should return strings, not bytes

Sample.csv contains the following: NAME Id No Dept Tom 1 12 CS Hendry 2 35 EC Bahamas 3 21 IT Frank 4 61 ...

June 3, 2022
0 Comments

C#, Programming

IT Nursery

How to read a CSV file into a .NET Datatable

How can I load a CSV file into a System.Data.DataTable, creating the datatable based on the CSV file? Does the regular ADO.net functionality ...

June 2, 2022
0 Comments

C#, Programming

IT Nursery

Reading CSV files using C#

I’m writing a simple import application and need to read a CSV file, show result in a DataGrid and show corrupted lines of ...

June 2, 2022
0 Comments

WordPress

IT Nursery

Export WordPress Table to CSV from page

I want to export my members table to csv format on my default download location. So I used a shortcode in functions.php and ...

June 1, 2022
0 Comments

excel, Programming

IT Nursery

How to correctly display .csv files within Excel 2013?

It seems Excel 2013 doesn’t read CSV files correctly (Excel 2010 does). Every time I open .csv files, all my data are displayed ...

June 1, 2022
0 Comments

excel, Programming

IT Nursery

Microsoft Excel mangles Diacritics in .csv files?

I am programmatically exporting data (using PHP 5.2) into a .csv test file. Example data: Numéro 1 (note the accented e). The data ...

June 1, 2022
0 Comments

linux, Programming

IT Nursery

Sorting a tab delimited file

I have a data with the following format: foo<tab>1.00<space>1.33<space>2.00<tab>3 Now I tried to sort the file based on the last field decreasingly. I ...

June 1, 2022
0 Comments

Database, Programming

IT Nursery

How to use mongoimport to import csv

Trying to import a CSV with contact information: Name,Address,City,State,ZIP Jane Doe,123 Main St,Whereverville,CA,90210 John Doe,555 Broadway Ave,New York,NY,10010 Running this doesn’t seem to ...

May 31, 2022
0 Comments

Programming, Python

IT Nursery

Read specific columns from a csv file with csv module?

I’m trying to parse through a csv file and extract the data from only specific columns. Example csv: ID | Name | Address ...

May 31, 2022
0 Comments