Questions tagged as 'csv'

Tagged questions
1
answer

Remove whitespace from csv

I have a problem when the user uploads a .CSV file. If some of the fields have a blank space at the end I can not remove it in any way. For example: "[email protected]" I have tried to use trim() , rtrim() and it does not work W...
asked by 02.08.2017 / 22:05
1
answer

convert decimal and date in LOAD DATA INFILE

I am importing a CVS file for MySQL. I have two columns: one quantidade and the other as data . I am trying to convert to the MySQL default. In the database this column is as decimal and date . It is importing all the l...
asked by 09.08.2017 / 03:26
1
answer

Text Processing in csv file

I have a database with more than a thousand reviews (text) in a csv file, however I need only texts that contain more than 5 words to be in my file. The problem is to make a code that scrolls the entire document line by line and leave only opini...
asked by 14.06.2017 / 01:38
1
answer

Same code producing distinct results in Codeenvy and Windows 8.1

I had made the following code in codevy.io and the Python installed in codenvy is 3.5.1. I got this code and put it to run on windows 8 with python 3.6.1. The purpose of the code is to clean up a CSV file and write them concatenated in a sing...
asked by 05.05.2017 / 16:52
1
answer

Reading CSV file and storing the data in a vector

I have the following difficulty: I need to read the data that is inside a CSV file and store it in an array to perform calculations with such data, but I do not know how to do it. I am using Python 3.6. Thank you in advance. My code looks lik...
asked by 27.04.2017 / 17:37
1
answer

Problem concatenating csv files

I'm trying to concatenate one csv file with another. My goal is to extract data from an HTML every day and my routine should get a csv file called 'old_date' where a saved dataframe is located in csv, and when I run again I should create a new u...
asked by 04.04.2017 / 16:10
1
answer

It is possible to generate a .CSV file from a table in a Firebird database

I need to Generate a .CSV file from a table in my Firebird database, is there any known tool that could help me?     
asked by 28.11.2016 / 17:08
1
answer

Error Django csv

Well, I'm having a problem reading csv and entering the data. I believe it's in the foreign key. The code is: View: def csvAih(request): coluna = 1 mes = 1 ano = 2008 while (ano < 2017): with o...
asked by 13.09.2016 / 00:48
1
answer

How do you assign data to a struct by reading from a CSV file?

I am having difficulty assigning read values from a file in csv format to one struct, my file has the following structure: 1;República Checa;156.9 2;Irlanda;131.1 3;Alemanha;115.8 4;Austrália;109.9 5;Áustria;108.3 And my code looks like thi...
asked by 23.04.2016 / 05:52
1
answer

Insert into a CSV file

I wanted to insert the table data (SQLite) into a CSV file. I make a query before, and I want to insert the result of that query into the CSV file. There is a fputcsv function in PHP. I can create the file but I wanted to insert it. Here...
asked by 12.11.2014 / 15:45