import-from-csv Questions

7

Solved

I'm trying to take data from a .csv file and importing into a HTML table within python. This is the csv file https://www.mediafire.com/?mootyaa33bmijiq Context: The csv is populated with data fro...
Enclosure asked 2/6, 2017 at 3:31

4

I'd want to read the CSV files modified( or created) most recently in differents directories and then put it in a pre-existing single dataframe (df_total). I have two kinds of directories to read:...
Simmonds asked 11/5, 2017 at 17:1

5

I'm trying to read in a .csv file from the IRS and it doesn't appear to be formatted in any weird way. I'm using the read.table() function, which I have used several times in the past but it isn't...
Rules asked 4/6, 2014 at 2:39

13

The CSV file that I want to read does not fit into main memory. How can I read a few (~10K) random lines of it and do some simple statistics on the selected data frame?
Elmiraelmo asked 7/3, 2014 at 19:0

4

I'm just learning d3, and I'm attempting to import data from a CSV file, but I keep getting the error "XMLHttpRequest cannot load file:///Users/Laura/Desktop/SampleECG.csv. Cross origin requests ar...
Ciapha asked 8/1, 2014 at 21:13

3

Solved

I have a small issue when I'm trying to import data from CSV files with numpy's loadtxt function. Here's a sample of the type of data files I have. Call it 'datafile1.csv': # Comment 1 # Comment...
Indiscernible asked 17/6, 2013 at 15:25

5

Solved

I wish to select a specific row and column from a CSV file in python. If the value is blank, I want to perform one action, and if the value is not blank, I want to perform another action. I think ...
Bridgeman asked 4/8, 2014 at 2:22

1

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 jo...
Krilov asked 4/5, 2017 at 16:29

2

Solved

I have imported a file with headings and numbers in multiple columns using the following command. irs_data <- read.csv(file="10incyallnoagi.csv") I would like to divide the values in 1 column b...
Heronry asked 8/10, 2014 at 0:31

1

I am trying to use Python Pandas to import a CSV file. The example data in this file is as follows where the first row is the column names separated by commas. End Customer Organization ID,End Cus...
Tingly asked 10/10, 2013 at 10:29

2

Solved

I have a tsv (tab separated file) that I would like to import with sqlite3. Does someone know a clear way to do it? I have installed sqlite3, but not created any database or tables yet. I've trie...
Whistling asked 26/9, 2014 at 18:16

3

Solved

I have a data set that is saved as a .csv file that looks like the following: Name,Age,Password John,9,\i1iiu1h8 Kelly,20,\771jk8 Bob,33,\kljhjj In R I could open this file by the following: X ...
Lamasery asked 23/1, 2013 at 20:24

2

I've got a CSV file with delimiter character being |, but can't really find a way to convert it to XLS that would apply the delimiter. ssconvert -O 'separator=|' test.csv test.xls will obviously...

5

Solved

I know this question has been asked a lot on this forum but I'm under a strict deadline and I need some help, so any advice is much appreciated. I'm new to Ruby on Rails so please keep that in mind...
Misreckon asked 17/9, 2012 at 14:18

1

Solved

I am trying to import some data from a .csv using d3.js. I am having trouble doing this, and was wondering if anyone could lend a hand. My .csv file is formatted like so: max_i,min_i,max_f,min_f -...
Painkiller asked 2/4, 2013 at 0:16

4

Is there a way to combine the use of scan() and read.big.matrix() from the bigmemory package to read in a 200 MB .csv file with mixed-type columns so that the result is a dataframe with integer, ch...
Quiver asked 7/8, 2011 at 4:29

2

Solved

I am trying to import CSV files to graph for a project. I'm using R 2.15.2 on a Mac OS X. The first way tried The script I'm trying to run to import the CSV file is this: group4 <- r...
Spaceless asked 17/1, 2013 at 10:25

2

Solved

I am trying to read a large tab delimited file in to R. First I tried this: data <- read.table("data.csv", sep="\t") But it is reading some of the numeric variables in as factors So I tried...
Rubber asked 26/7, 2012 at 18:41

3

Solved

I have a csv file with ~200 columns and ~170K rows. The data has been extensively groomed and I know that it is well-formed. When read.table completes, I see that approximately half of the rows hav...
Infuscate asked 16/4, 2011 at 4:43

3

Solved

https://joshclose.github.io/CsvHelper/ available via NuGet is used to read and write CSV files. CsvHelper allows you to read your CSV file directly into your custom class. As following was shown ...
Screeching asked 31/3, 2011 at 8:3

2

I have a very large CSV file (150 MB). What is the best way to import it to MySQL? I have to do some manipulation in PHP before inserting it into the MySQL table.
Institutionalize asked 23/9, 2010 at 7:26

2

Solved

The read.table and read.csv functions in R are used to parse a file or URL containing delimited data and produce an R data frame. However, I already have a character vector that contains the CSV de...
Orford asked 16/7, 2010 at 0:22
1

© 2022 - 2024 — McMap. All rights reserved.