Questions tagged as 'csv'

Tagged questions
0
answers

Read CSV files and create their respective tables in mysql

This is the function of my button when loading multiple CSV files, I would like to know how to implement the function so that those files can be generated in tables in MYSQL in a database that I already have . private void examinarAct...
asked by 15.11.2018 / 20:15
0
answers

Error Code: 1290. The MySQL server is running with the - secure-file-priv option so it can not execute this statement

I am trying to enter data into a MySQL bd from a .csv file and when executing this command line: load data infile 'C:\respaldo\respaldo.csv' into table productos fields terminated by ',' lines terminated by '\n' ignore 1 lines; I get this e...
asked by 16.11.2018 / 03:03
0
answers

Load csv spark file 2.3.0 to analyze it with k-means

I am new using Apache Spark, version 2.3.0. I am based on the sample code that comes in the Spark page to be able to use the k-means algorithm. I make the example shown below and run it perfectly, but when trying to use it with csv file the erro...
asked by 03.10.2018 / 06:07
1
answer

Read CSV with thousands of records and insert into batch database

I need to read and insert a CSV of more than 100,000 records. I have achieved that if it is of a small size of rows I do what I want, but when I work with the size that I mention, it blocks the page. My idea was to do this in batches, for exa...
asked by 18.09.2018 / 18:13
0
answers

Take data from a string CSV String C #

I have a small application in C # for desktop where I have a method that makes a request get that in response it receives a string with the contents of a csv file, when I already have it catched I remove the spaces with the trim method and I'm l...
asked by 28.08.2018 / 18:39
1
answer

Generate csv file from matrix (nested lists)

I have a 1000x5 matrix, in the format ['1', 'Visa', '4539897685939002', '116', '5/2022\n'] All values within each row are strings and are sorted increasingly by the first index of each row, something like this: ['1', 'Visa', '453989768593...
asked by 16.08.2018 / 01:28
0
answers

Reading problems with CSV and PHP [closed]

I tell you my problem: I download from Facebook a list of potential customers obtained to hear canoalas advertising. That file is in CSV UTF-16 format. What I do first of all to modify the encoding and pass it to UTF-8 is: iconv -f UTF-1...
asked by 14.08.2018 / 17:59
1
answer

Replace values in a CSV Python

I'm lost with something. I have a csv file that I import with Pandas to be able to convert it into an Numpy array, and I have the following function to replace values in the original CSV file: # Cargamos el archivo en la variable data, com...
asked by 30.06.2018 / 18:45
1
answer

Help with the error: can not call getOutputStream () after getWriter (), when trying to perform a file download in java?

I have the following method in the controller, which returns a json type response to the view, to show in a dialog whether or not there is data in the bd according to the information of the parameters that happened to my service. @Req...
asked by 13.06.2018 / 06:51
0
answers

How to validate a data from a csv with an input text, with javascript?

I am new to web development, surely what I am asking is very simple but I can not find a clear solution. I have a single-column .csv file with pure numbers on the server-side doc / series.csv path, and from a javascript I want to read it so t...
asked by 21.06.2018 / 21:31