Most voted "csv" questions
CSV (Comma-separated values) is a file format primarily used by Spreadsheet or Database applications to represent a data table. Its main characteristic, as the name already says, is to use only values and commas in its structure.
Learn more…343 questions
Sort by count of
-
1
votes1
answer187
viewsSum and Multiplication with items of a CSV
good night! I’m new to programming and I’m learning to code in python. Also, I’ve been trying to create something that’s relatively simple, but I’m finding it difficult to execute. I imported a list…
-
1
votes0
answers400
viewsImport CSV File to SQL - Delphi
I have a program in Delphi that imports certain CSV file to an SQL database in order to later compare the data between different versions of the same file, for example a version of the file is from…
-
1
votes1
answer108
viewsFor nested only works in first iteration (Python)
I’m trying to get one nested to compare lines in two different csv files, but after the first interaction of the first file is searched inside the second file and skip to the second iteration, the…
-
1
votes1
answer100
viewsInput with fgets
Hello, I’m having the following difficulty, the moment I call the function of fgets, regardless of whether on any parole, or in the registration function it does not work. At the moment when…
-
1
votes2
answers226
viewsPowershell file output. CSV after Foreach
Good afternoon! I have a simple powershell scritp that performs the connection test between Omains controllers and their respective service ports as below: $servers = Get-Content -Path 'C:\DC…
-
1
votes1
answer74
viewsSuggested improvement of code, for opening of several csv files in different directories
Good evening friends, a friend passed me a code that he was developing so that I could study, however I would like to see a better alternative to the opening of various files . csv, only they’re in…
-
1
votes1
answer442
viewsPython - Typeerror: int object is not iterable
This is my code: import csv def gravar(nome,idade, sexo): with open('cadastros.csv', 'w') as arquivo_csv: colunas = ['Nome', 'Idade', "Sexo"] escrever = csv.DictWriter(arquivo_csv,…
-
1
votes1
answer193
viewsConsolidate . csv files with Python
Good Night, please help me with the question below? I am developing a program that reads all csv’s with the same content of a folder and consoles them in a single file, disregarding the first line,…
-
1
votes2
answers104
viewsInsert text into its proper cells - Python
Hello, my friends I am developing the code so that I can clean and organize the data (as shown above) and one of the best ways was to insert the data into a file CSV so that later I could return it…
-
1
votes0
answers17
viewsConvert CODA object to CSV
I’m using "Hierarchical Modelling of Species Communities (HMSC)", and I used the "convertToCodaObject" command to view the model’s empirical information (e.g., mean and sd). However, I’m having…
-
1
votes0
answers25
viewsCSV file does not record all data in the database
Good evening, in my code when I send the CSV file It records only the last line of the file, when I use TRUNCATE TABLE. Without the truncate saves all lines, but the goal is to update the data by…
-
1
votes0
answers46
viewsProblem with ARRAY_SEARCH function and Matrix in PHP
Hello, I’m making a PHP code that picks up a CSV file and am separating the file by "column" States. I want to make a matrix separating the states that repeat as follows:…
-
1
votes0
answers66
viewsPHP to receive data from a CSV file via POST with Ajax
I need to upload a CSV file via a form, pass to PHP using Ajax, parse the file and receive a return. I was able to send the file, but I can’t get the data from the file to analyze. My CSV file:…
-
1
votes1
answer19
viewsProblems writing converted uuid from Binary(16) to csv file
From a query in MySQL I receive lines with the field in the format binary(16) of MySQL. I do the conversion using lib uuid and try to insert into a file csv. Does not write in format uuid in the…
-
1
votes0
answers123
viewsGenerating CSV file with Fast-csv in Nodejs
I need to write a CSV with data from a JSON, but I cannot generate the file with the data. I am using fast-csv Package. No error is reported during execution. Follows my code: async function…
-
1
votes0
answers45
viewsLaravel Excel maatwebsite validate spreadsheet before importing to database
I am trying to validate a spreadsheet before importing it to the database, I need to check if there is any date above today’s date in the file, but I can only check the first line and there may be…
-
1
votes1
answer76
viewsGenerate csv file in Excel standard with Csvhelper C#
I created a project to generate a . csv file (which will be used in Excel). So far it is working normally and is being generated in the format "Excel . csv", but the problem is that when opening the…
-
0
votes1
answer361
viewsImport CSV files to Mysql Workbench
I have a file .csv which contains in columns (vertically): Product.1 (line1) Product.2 (Linha2) But when I do this query: use test; LOAD DATA LOCAL INFILE 'local' INTO TABLE tabela1; Always give me…
-
0
votes1
answer75
viewsInsert into CSV file
I wanted to insert the table data (Sqlite) into a CSV file. I do a query first, and I want to insert the result of that query into the CSV file. Exists in PHP the function fputcsv. I can create the…
-
0
votes0
answers123
viewsRead 2 or more csv files
I created a script where the user will send one or more CSV files, it will send and then php should take the name of that file and make some changes (system requirement)and save in the database and…
-
0
votes1
answer892
viewsImport CSV files to Mysql using LOAD DATA LOCAL INFILE
I used the following script to import a file .csv to Mysql using the MySQL WorkBench: USE test; LOAD DATA LOCAL INFILE 'exemplo1.csv' INTO TABLE tabela1 fields terminated by ';' lines terminated by…
-
0
votes0
answers174
viewsPutting header into CSV file
I have on a client’s page a log generation routine. However, I always need to add a header field on the first line. Here is the function code: public function generateLogPMWeb($action){…
-
0
votes1
answer1130
viewsHow to show the value of a variable that is in another html page
The problem is this: I need to see some values that are updated every 3 seconds in a file that can be a .html, .csv, .txt or .css, any extension that can be seen in the notepad. Would look like this…
-
0
votes1
answer419
viewsRounding up
I have the following list of dictionaries and the values correspond to the average value , for example, in the first appears 4 , but in fact of the 4.6666. I’d like to know how and what it does , I…
-
0
votes1
answer44
viewsWrite to a csv file with JSP without overwriting what you already have
I have this code below to record information in the csv file, but whenever I record something, what I have already written is lost. How do I get him to add a line with the new information keeping…
-
0
votes1
answer155
viewsHow to extract data from a Django Queryset
I have a table with some information, the employee’s name, Pis, date and time, the time field records the time of registration on the time clock, these records are all in the same column, for…
-
0
votes1
answer568
viewsExport Gridview to CSV in excel file / VB.NET
Following examples found on the web and even stackoverflow I filled the button btnGerarCSV thus. Protected Sub btnGerarCSV_Click(ByVal sender As Object, ByVal e As EventArgs) Handles…
-
0
votes1
answer119
viewsIt is possible to generate a file . CSV from a table of a Firebird database
I need to generate a file .CSV from a table in my Firebird database, there is some known tool that could help me?
-
0
votes1
answer63
viewsCSV file saved in the database
I have a large CVS file and I need to record it in my database the first line are the fields, which I have to validate if they are right and make some changes for example first line NAME, DATE…
-
0
votes1
answer259
viewsUpdate. csv file when edited in Java
I have a . csv file that contains information, but when I delete information (in this case contacts) from the console output the file . csv is not being updated. How to resolve? private void…
-
0
votes1
answer1375
viewsHow to upload data to CSV in oracle SEM SQL Loader?
Data from a table was exported in a CSV file and I would like to import it into a table in the Oracle database. But I need it to be without the sqlldr command. Because this load will be done in…
-
0
votes1
answer521
viewsHow to Import CSV File to Mysql? Error 1295
How to import a CSV file to Mysql? I get error code 1295: ERROR 1295: 1295: This command is not supported in the Prepared statement Protocol yet SQL Statement I sent the command: LOAD DATA LOCAL…
-
0
votes1
answer4423
viewsCSV file reading and data storage 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 don’t know how to do it. I’m using Python…
-
0
votes1
answer945
viewsHow do you assign data to a struct by reading from a CSV file?
I’m having difficulty assigning read values of a file in csv format to a 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…
-
0
votes1
answer185
viewsHow to use Python integrated with . CSV
Good morning. I have to read a field(line) from a file in . csv and fill in a certain field on the system. How should I do? Example, man . csv is the mass of data for filling in a register.
-
0
votes1
answer406
viewsRemove white space from csv
I’m having a problem when the user climbs up a .CSV. file If in some of the fields there is a blank space at the end I can’t remove it in any way. For example: "[email protected] " I’ve tried to use…
-
0
votes1
answer900
viewsRead a CSV file
I was able to import the csv inside the cell, however when trying to read the file so that the application does the information inside csv it happens an error: java.io.Filenotfoundexception:…
-
0
votes0
answers91
viewsBug reading csv by http request (Webservice)
I am having trouble reading a csv file via http request. It would be a Restful webservice that receives a csv and uses its contents. I’ve tried to read it in different ways, with opencsv, Javacsv..…
-
0
votes1
answer1057
viewsWrite CSV file in a certain line passed by parameter c#
How to write in a CSV file, in a certain line I will receive by parameter, example of the beginning of the code: public void EscreverCSV(string caminho, int linha, string mensagemErro) { using…
-
0
votes0
answers443
viewsExport Mysql data to CSV file in UTF-8 format
I’m used to the tool Workbench to access data from my Mysql database, but when I try to export the returned data to a file *.CSV I am unable to export the same in the format UTF-8, but is exported…
-
0
votes1
answer308
viewsSave array to different columns with fputcsv
I am trying to output some data from BD to csv with the following code: while($linha=$buscar->fetch(PDO::FETCH_ASSOC)){ fputcsv($out, $linha); } fclose( $out ); } which returns all the contents…
-
0
votes1
answer73
viewsHow to apply recursive action to csv.Dictreader
Hello, I created the following code but it only applies the function of creating the txt file using the last record of the CSV table, as I can do for it to create a file for each record of this…
-
0
votes1
answer1183
viewsCreate a *.csv file with found data from a file
I am developing a project that extracted information from a *.pdf file, was saving this information in a *.txt file, but now I was asked that this information be saved in the format of a…
-
0
votes3
answers3451
viewsHow to count the records of a csv in python?
I’m a beginner in Python and I’m having a hard time. I have a CSV database separated by ";" with 6 columns. I’d like to count how many records you have, the sex of which is "Female". You can tell me…
-
0
votes1
answer437
viewsAccessing . csv file with PHP
I would like to know how I can collect and store column data in a. csv file with PHP?
-
0
votes1
answer822
viewsPython CSV How to rewrite only one line of the file?
I have a row that stores within the file the following columns: ID Nome Telefone Descrição DataEntrada HoraEntrada The ID is basically the line number and it is through it that I will seek to know…
-
0
votes0
answers50
viewsNo reading of csv file on D3
I’m trying to make a file. Md that houses three views. When it arrives at the second view (graphic) it gives the error below in the browser console. I am trying to load a csv file that is in the…
-
0
votes1
answer524
views -
0
votes1
answer59
viewsHow to find out which line is any CSV data
Good afternoon, I have a problem that I do not know how to solve, probably will be in PHP but I have no idea how to do this. More precisely what I need to do is: I have a website, and in it I will…
-
0
votes0
answers45
viewsCAST in multiple columns to 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 do a CAST in these columns and then take…