Questions tagged as 'csv'

1
answer

Iterator should return a String

Hello, I have the following code: import csv def carregar_acessos(): X = [] Y = [] arquivo = open('acesso_pagina.csv', 'rb') leitor = csv.reader(arquivo) next(leitor) for home,como_funciona,contato,comprou in leito...
asked by 13.11.2017 / 23:52
1
answer

Delete Last Row - Java

I'm reading a CSV using BufferedReader reading row by line converting the result to a .txt. At the end of my txt is generating a line break after the last item. I'm trying to find a way to remove last line break after the last item in the list....
asked by 05.10.2017 / 16:29
1
answer

Read CSV file, Columns [duplicate]

I would like to know how to read a CSV file by taking the first and second column and compare the string contained in it with another string I want in the code. Eg: if(o conteudo do csv coluna 1=="positivo" && conteudo do csv colu...
asked by 25.07.2017 / 20:04
1
answer

Select a row where a column has an element of a CSV

I have a table in the database with the following structure: +---------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+---------+------+-----+---------+--------------...
asked by 15.03.2017 / 18:35
1
answer

Delete words from a file

I have a file CSV and I have this list of words here: link The CSV file has 3 columns, Text, user.name, and Class, and has about 100K of rows. I need to exclude from the first column of CSV all the words that appear in...
asked by 02.04.2017 / 19:25
1
answer

How to load data in CSV in Oracle SEM SQL Loader?

The data in a table has been exported to a CSV file and would like to import it into a table in the Oracle database. However I need it to be without the sqlldr command. Because this load will be done in Java, and I have restrictions on using SQL...
asked by 04.01.2017 / 11:05
1
answer

Compare fields in two data sets

Consider two sets of data read from files of type *.CSV with Pandas . Each set has only one CPF Favorecido field, which contains millions of records. Each set of data is equal to one month. I need to find out what records (CP...
asked by 24.05.2016 / 19:11
1
answer

Problem using javascript, JOD NODE and CSV database

Hello I'm doing a project for school using IBM's Bluemix and I'm having some problems finding my error. I am using a database in CSV that has as parameters the neighborhood, number of rooms, area in square meters, price among other informatio...
asked by 19.12.2015 / 23:01
2
answers

Add a fixed line every 50 PHP CSV lines

I have a problem. I have a CSV file with 490 lines (on average, this value may vary) and would like to add 1 certain number every 50 lines. Each line basically consists of 10 numeric digits and after these digits, a new line is created (if I'...
asked by 14.10.2015 / 17:00
1
answer

Problem importing text file via VBA

I'm trying to import a text file into excel through the following macro: Sub Teste() Dim intervalo As String intervalo = "intervalo" Workbooks.Add ActiveWorkbook.Sheets("Plan1").Select With ActiveSheet.QueryTables.Add(Co...
asked by 10.07.2015 / 21:31