Questions tagged as 'csv'

Tagged questions
0
answers

CAST in several columns to take the average

I have several columns in a csv table, I imported the table into mysql, but when I import into mysql I have to do this import as varchar for all data. If I make a CAST in these columns and then take the average I believe it will give the value o...
asked by 26.04.2018 / 00:37
0
answers

Export query to CSV file with PHP

I have a PHP code that does a query in the database and was to return the values to a CSV file, but this is not happening. The script is even returning the query, but the values are only in the browser and the CSV file is not created. I'm using...
asked by 15.04.2018 / 03:01
1
answer

How can I tabulate a bulk file?

Hello, I have a file of 64500 rows and 11 columns to tabulate. The original file came from the counter system, which is a system for printing paper. I've been able to get the headers out, but I'm having trouble with the tab. Does anyone know of...
asked by 17.04.2018 / 23:23
1
answer

How do I change the csv header, C #

I am generating a CSV file, but I would like the header to be equal to anottation displayName . When I export, displayName is ignored. method call string csv = ListToCSV(resultado); private string ListToCSV<T>(IEnumerable<T>...
asked by 19.03.2018 / 18:36
0
answers

Delete empty rows at the end of a CSV file with PHP

Hello, I need a hint, I was importing a file in CSV to change a record in my database and strangely I could not do it, I did an analysis in the code in PHP and it's alright so I left for the file in CSV and I discovered that...
asked by 16.02.2018 / 13:46
0
answers

Search in a .csv file in C

Hello! I'm new to programming, and for a college job, I have to create a project in which I have to use .csv files. The program itself compiles, but I know I have an error in an if function, and I can not identify it. I searched for examples, bu...
asked by 14.02.2018 / 16:21
0
answers

Read csv file in a 2-d array and edit data in C

I have a csv file and I want to read it in an array and then edit the values of a certain position. Here is an example of my file: id; a; b; c; d; e; f; g; h 1; ; ; ; ; ; ; ; ; 2; ; ; ; ; ; ; ; ; 3; ; ; ; ; ; ; ; ; (...) I declared an ar...
asked by 14.02.2018 / 16:25
1
answer

Edit .csv files in C

I need to make a programming code in C, in which I ask the user for the name of a city, present in the first file (cities.csv), and I have to remove the id from the inserted city. Then, this id must match another id, present in a second file (me...
asked by 15.02.2018 / 18:44
0
answers

Remove a line in a .csv file in C language

For a college job, I have two .csv files, and I have to create a function to remove data from those files. But I do not know where to start, and what code to use. I already researched the internet and found nothing. If they give me an example fo...
asked by 17.02.2018 / 00:05
1
answer

Export table (in pd.DataFrame) to csv - Python format

Are you okay? How to export or save a table made with pandas.DataFrame in csv or xlsx format in Python?     
asked by 06.02.2018 / 11:49