Questions tagged as 'csv'

1
answer

in R, dec="," does not work in read.csv2

Good afternoon ... I'm trying to import csv where the decimals are separated by a point ... or something like 2.5 I want it to come up with a comma, something like that, 2,5 uo_14<- read.csv2("csv\uo_2014.csv", as.is = FALSE , header =...
asked by 29.11.2014 / 17:49
2
answers

Remove blank lines in a csv

I'm trying to remove empty rows from a csv document: Document:    sentence, lingua      ., pt      ., in      ., in      ., it      ., en      ., pt      ., pt      ., en      ., pt      ., pt       "it's not expensive", in   ...
asked by 25.06.2018 / 11:52
1
answer

Get String data from a CSV document

I have a CSV (Excel) document with valid and invalid emails. And I wanted to get the values of the fields in the form of string , but the following code gives the return shown below: import csv import re ifile = open('ead.csv', "r") read =...
asked by 03.04.2018 / 20:15
1
answer

Keep characters in substitution with regex in gedit

I have the following text segment in a .csv file 5/29/17;08:17;Fulano;Teatro Companhia Rua do Canto, 301/305 Esquina da rua meio De segunda a sexta das 9h as 18h 5/29/17;08:18;Ciclano;legal I need to have lines 2,3 and 4 together with line...
asked by 16.08.2017 / 17:15
1
answer

Error trying to save txt

Personal good morning,  I have this code block: $delimitador = ';'; $cerca = '"'; $VarDataAux = ''; // Abrir arquivo para leitura $f = fopen($_FILES['arquivo']['tmp_name'], 'r'); if ($f) { // Ler cabecalho do arquivo...
asked by 30.06.2017 / 13:34
1
answer

Read Data from a .csv file and pass line values to Tuple

The data in the cities.csv file is organized as follows: Lisbon, Madrid, 600 Madrid, Paris, 650 import csv with open('cidades.csv', 'r') as f: # Somente r para leitura do arquivo list1 = [tuple(line.values()) for line in csv.DictRe...
asked by 09.11.2017 / 02:53
1
answer

The PN0 control number V0102 does not correspond to the IBGE municipalities code. How to join the banks?

Hello I am working with the food supplements of pnad04 , pnad09 and pnad13 of IBGE and with two other banks of IPEA, one on municipal GDP ipea.pib and another on investments in social programs by municipality% with%...
asked by 01.02.2016 / 05:24
1
answer

How to compare dates coming from a CSV file in Ruby

Good personal I have a CSV file with some data in it in case this: Nome; Data; Salario JOANNA 1981-04-11 7519.07 LUCIMAR 1958-06-10 819.77 PEDRO 1976-05-11 83.43 JOAO 1989-03-12 867.5 CAIO 1954-02-13 88.6 JULIANA 1958...
asked by 04.07.2015 / 05:31
4
answers

Breaks row in table cell in CSV format to be read by Excel

I have the following code that inserts a value into an excel cell for export context.Response.Write("aa\r\nbb\r\nccc"); o / r / n breaks the line but writes in the cell below, I would like to break the line but continue with the text in the...
asked by 03.04.2014 / 17:41
1
answer

PHP - Accessing CSV file and printing specific cells on the screen

How to access a .CSV file via PHP and print a specific cell on the screen ?! Example: Column A - Line 1 It is written: Alexandre How to get this cell from "A1" and print on the screen?! I want to apply this in this DASHBOARD:...
asked by 11.08.2017 / 14:38