Questions tagged as 'csv'

Tagged questions
2
answers

How to import data (.csv) into the R while retaining the original format

I'm trying to import Excel data (already in .csv format) into R; the values contained in the files to be imported are in the following formats, for example 8509,80 ... To do the import, I am using the command: variavel=read.table("dados.csv...
asked by 04.07.2015 / 15:07
1
answer

Perform a filter and save in csv

I would like to perform a filter in R. I have a database with 5 variables and more than 5000 rows. One of my variables is "room", in which I have 29 room (ex: room 1, room 2 ...). I would like to perform a filter, to filter all the informatio...
asked by 13.04.2015 / 17:22
1
answer

Read CSV file without saving it

I have following code: [HttpPost] public ActionResult importCSV(HttpPostedFileBase file) { if (file.ContentLength <= 0) { ViewBag.Message = "Nenhum arquivo foi enviado.";...
asked by 09.06.2015 / 16:32
1
answer

How to transform imported Excel data (.csv) into time series

Imported an Excel database for R and need to transform them into time series so that you can analyze them. However, when I make the transformation to time series, the R changes the original values to totally different ones. Here are the steps I...
asked by 05.07.2015 / 14:55
2
answers

Generate CSV with side-by-side results in PHP

I'm trying to get comparative results in a CSV generated in php but I can not stack side by side in the way it illustrates EXPECTED OUTPUT attached image. I made a code below that did not break the line when it changes to 2018 TABLE...
asked by 23.04.2018 / 22:17
1
answer

Reading CSV file accented in Python?

I'm learning python3 and I ended up packing on the issue of reading a simple csv file that contains the character 'à'. I've tried using decode, encode that I found on the internet but nothing seems to work, it is always printed as '\ xc3 \ xa0'....
asked by 26.12.2016 / 05:38
1
answer

How to load data to MySQL faster?

I have a DER that represents an airport and I have to load data from several csv there. for example I have a connection from 1 to many, from airline to flights. If I have this table linked with the foreign key it gives me error loading data so I...
asked by 15.09.2015 / 03:56
1
answer

How to save an XLSX (Excel) file instead of CSV?

Today I have the code below, which saves a file in CSV format. What do I need to change to save in XLSX (Excel) format? public static void buildCSV(string filename = "resultado.xlsx") { Console.WriteLine("Escrevendo no a...
asked by 30.11.2018 / 22:23
2
answers

Check tab type in a CSV file

I've set up a script to import CSV with PHP but I'm having difficulty checking the type of CSV formatting. I need to check if it is separated by , or ; or \t or : or | , but I can not....
asked by 16.06.2015 / 19:04
1
answer

Count how many columns there are in a CSV file with C ++

I am doing a project for an electronic ballot box, and for this I need to read a csv file where there is information about each candidate. As this csv file has a lot of information that is not relevant, I decide to use only certain columns of...
asked by 08.09.2018 / 05:55