Questions tagged as 'csv'

1
answer

Parsing columns of numbers from a CSV file in C

Hello, Good Night I have a simple .CSV file, containing only two columns, separated by a comma and the new line, as an example: 0.001,-9.623 0.098,2.540 1.000,-1.002 And you need to separate them preferably in two vectors, or in an array...
asked by 19.03.2018 / 02:23
1
answer

.csv export with row complement based on a fixed number

I have a MySQL table of products. I need to create a .csv export of them. The products are on the bench as follows: cod produto valor pagina 123 caderno 1,00 1 456 lápis 1,00 1 789 borracha 1,00 1 112...
asked by 18.12.2017 / 20:15
3
answers

Next () in CSV Reader with Python 3

Hello, I'm doing a Machine Learning / Classification course and well it uses a CSV file in which one should ignore the first line of the file. Then I made the following code: import csv def carregar_acessos(): X = [] Y = [] arqui...
asked by 09.11.2017 / 01:00
2
answers

Format date and monetary value to save to the database

I'm extracting data from a .xlsx file. converting them to .csv and displaying on the screen. So far so good, however, I want to play this data in a database using PHP, but for this I need to convert the data, because the way they a...
asked by 15.12.2015 / 21:49
1
answer

Remove Blank Lines in a Csv File

I have the following csv file and would like to remove the lines that are blank For example .csv file "C","C","X","123","asdsd","'232","'323","","323","23","4","dsa","dsad","dsa","ds","dsad","sdad,","24","0","11","4,2","fdf","","k","502"...
asked by 27.11.2015 / 14:01
1
answer

Values search with PHP - Is it possible?

Is it possible to access a .CSV file, capture a value and search it in another .CSV file ?! Example: Note: The images below are from .xlsb files, but for demonstration purposes only, I am using .csv files The code should in the case s...
asked by 26.09.2017 / 18:11
1
answer

Generate output in csv from a code in python

I hope you can help. I'm new to python and my question is this. I created a regex that extracts from a file in csv the parts of the text that I want. But I want to save the output of this function in csv to compare with the start tabl...
asked by 17.10.2016 / 14:43
1
answer

Because my program does not generate CSV in UTF-8 that can be read correctly by Excel, but notepad generates

I have generated .CSV files in javascript , in UTF-8, but they are not read with correct encoding in Microsoft Excel (generating invalid characters instead of accented ones, as if I had read ISO 8859-1 or something like this). Mo...
asked by 29.08.2016 / 22:35
1
answer

Import .csv file to server

I am performing a task to import data from a .csv file to the server. I can already import the file all right on the server side, however each file contains about 25,000 records and the user is waiting until the upload is complete. I put a simpl...
asked by 16.02.2016 / 20:22
2
answers

Forms and Files

I'm making a form where I basically access a .txt file in CSV format that contains some articles and their prices (eg cheese, 2.10). The program displays the list in a table, and below are two fields that ask for "Article" and "Quantit...
asked by 12.10.2016 / 16:29