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
-
2
votes2
answers9602
viewsGenerate csv file in php
Hello guys I am trying to create a php query in mysql database to generate a csv file according to the code below. The problem is that the part that would download the file is showing error, I…
-
2
votes4
answers4316
viewsHow to import a csv file to Mysql?
I am starting my studies in Mysql. I decided to install Mariadb 10.1.14 in Centos. I want to create a database from a file . csv with about 166 million lines. I looked for tutorials on the internet,…
-
2
votes1
answer1043
viewsRead Data from a. csv file and pass line values to Tuple
The data in the.csv cities file is organized as follows: Lisbon,Madrid,600 Madrid, Paris,650 import csv with open('cidades.csv', 'r') as f: # Somente r para leitura do arquivo list1 =…
-
2
votes1
answer979
viewsExport CSV data via JS
I have a data set in the database in my back end, and I need to create a button on which the user will click to export this data in CSV format. But I have never done this type of event in J. Someone…
-
2
votes2
answers1801
viewsHow to join two csv files in R?
my problem is the following: I have two data files in csv format with same number of columns and same column names (see below). I ask to read the files as follows: > dados_1 <-…
-
2
votes2
answers445
viewsHow to concatenate value to a column of a table in csv?
I’m having a hard time creating an algorithm that adds an element to the third row in the CSV file in the Python language. The file has following data: Serial; Imei; Número; Icc; Stock…
-
2
votes2
answers1499
viewsRemove all line breaks from just one column of a csv file on Linux
I have a file csv with more than 500k of lines and need to remove line breaks from just one column efficiently in addition to deleting all the links it contains, a snippet of the file:…
-
2
votes1
answer495
viewsinput type file does not load file. CSV
Hello, I’m trying to get the data from a file. CSV with php, but when using the input file to get the . csv is not loading html code <form id="form" name="form" action="add_analise.php"…
-
2
votes0
answers785
viewsPython Pandas CSV
I started to learn Python not long ago and I’m doing a project to normalize customer data. But I don’t know how to make a comparison like: read on CSV field CP7, search for all CP7 of CSV CTT and…
-
2
votes2
answers349
viewsImport csv - 18 million lines in R
How to import a base of 20 million lines with 24 variables. There are two variables that are string. The base is importing these two variables as Numeric and excluding the zeros at the beginning. I…
-
2
votes1
answer141
viewsProtect Excel spreadsheet in C#
In a C#application, you can have from 1 to 2100 hours of data collection. Data is saved in a CSV Excel spreadsheet every minute. With the code below we can hide and show the file. #region string…
-
2
votes1
answer234
viewsCSV file reading and vector line storage
I need to read a csv file and store each one line of the file into different vectors. After that, convert these vectors to new csv files. The problem is that my code generates two vectors with data…
-
2
votes1
answer63
viewsError trying to save txt
Everybody, good morning, everybody, I have this code pad: $delimitador = ';'; $cerca = '"'; $VarDataAux = ''; // Abrir arquivo para leitura $f = fopen($_FILES['arquivo']['tmp_name'], 'r'); if ($f) {…
-
2
votes2
answers3195
viewsError importing data . csv to Rstudio
When I will import and create a file my data to the R it error... I tried the following way: melipona <- paste(system.file(package="dismo"), "/ex/Melipona.csv", sep=";")…
-
2
votes1
answer213
viewsPHP - Accessing CSV file and printing specific cells on screen
How to access a. CSV file via PHP and print a specific cell on the screen?! Example: Column A - Row 1 It is written: Alexander How to take this cell from "A1" and print on the screen?! I want to…
-
2
votes3
answers1421
viewsforeach - Browsing CSV archive
I need to scroll through a CSV file to capture a value and print it on the screen. Example: Column "N" line "2", in this case it is cell N2 that is written: 2,98 How to print this N2 cell on the…
-
2
votes1
answer109
viewsKeep characters in replace with regex in gedit
I have the following text segment in a . csv file 5/29/17;08:17;Fulano;Teatro Companhia Rua do Canto, 301/305 Esquina da rua meio De segunda a sexta das 9h as 18h 5/29/17;08:18;Ciclano;legal I need…
-
2
votes2
answers238
viewsmanipulating csv file
good people. I need to use a csv file, which has more than ten columns and two thousand lines. I’m not sure how to get a single column. this program below, I took on the internet. separador = ','…
-
2
votes2
answers68
viewsIterator should return a String
Hello, I have the following code: import csv def carregar_acessos(): X = [] Y = [] arquivo = open('acesso_pagina.csv', 'rb') leitor = csv.reader(arquivo) next(leitor) for…
-
2
votes1
answer83
viewsGet String Type Data from a CSV Document
I have a CSV (Excel) document with valid and invalid emails. And I wanted to take the values of the fields in the form of string, but the following code gives the return shown below: import csv…
-
2
votes2
answers109
viewsFind and Replace in bash
I need to find outdated lines in a csv file and replace them with new lines. These are the commands that find the lines that will be replaced(old) and that will replace(new). linhas_antigas=$(diff…
-
2
votes2
answers1413
viewsRemove blank lines in a csv
I am trying to remove empty lines from a csv document: Document: phrase, .,pt .,en .,en .,it .,es .,pt .,pt .,es .,pt .,pt "it’s not Expensive",en "casi 50 euros la alfombra es cara", " the price…
-
2
votes2
answers1277
viewsHow to manipulate a CSV file column?
Hey, guys! What’s up? I am learning Java and need help with CSV files. I can read the file, but I need to perform operations with a few columns. Example, with fictitious data, of the table I am…
-
2
votes1
answer1373
viewsHow to add values of a csv using Python?
I have a csv file similar to this, with all the information of all the municipalities of Brazil (I shortened the csv to not get too extensive): ESTADO,MUNICIPIO,HABITANTES,AREA…
-
2
votes0
answers705
viewsHow to replace single quotes with double quotes in python?
I used the function replace to replace single quotes from a field in csv with double quotes, but in output the value comes out with escape character , it is this character remains when clicking to…
-
2
votes1
answer185
viewsSearch within csv and bring other row columns - Python
Well I have a Python application that generates a csv file of 7000 lines and 4 columns, for example: Mesa,Entrada,Saida,Conta "P",21:00,22:00,95.00 "A",14:00,18:00,195.00 "C",18:00,21:00,75.00…
-
2
votes1
answer2901
viewsValueerror: could not Convert string to float: 'red'
Hello, I’m trying to make a model for deciding white and red wines, this is my code: from sklearn.model_selection import train_test_split import keras from keras.models import Sequential from…
-
2
votes1
answer73
viewsPlot horizontally (column by column) - Python
Good afternoon, my friends All right? I have an XML file from which I would like to remove the data as shown below and plot in columns, not row by row as the code is performing, in case the data…
-
2
votes1
answer145
viewsdefine average function with pandas
I have a csv file that measures the temperature of every day of the year and I need to calculate the monthly average. I created a loop and even that worked but I wanted to know if there is a way to…
-
2
votes1
answer55
viewsInserting CSV into Postgresql with Nodejs
I want to insert a CSV into a postgresql table. CSV contains rows with multiple column numbers. Ex: 1,2,3 1,2,3,4,5 1,2,3,4,5,6 1,2,3,4 When performing the insertion, the following error occurs:…
-
1
votes1
answer566
viewsRuby on Rails read csv file and fill table
I have following table news : create_table "noticia", force: true do |t| t.integer "conteudo_id" t.integer "entidade_id" t.integer "imagem_id" t.string "texto" t.datetime "created_at" t.datetime…
-
1
votes1
answer836
viewsImport PHP CSV file
I have a CSV file with contacts. I want to import these contacts into a sqlite database. How can I read the file and insert it into the database?
-
1
votes1
answer1299
viewsCreating Schedule to transfer CSV files from Winscp to FTP
I need to transfer CSV extension files that are in a folder of my Linux server (accessible via Winscp by Windows) to an FTP. For this, it is necessary to create a Schedule that makes this transfer…
-
1
votes1
answer560
viewsResponse.Write/Flush hangs after many calls
DISCLAIMER: I posted the same question in Stackoverflow in English, I will carry the valid answer from here to there or from there to here if necessary, but I know that not all users here access…
-
1
votes0
answers217
viewsNotepad++: how not to escape the backslash
This is perhaps a trivial doubt. But how to do for Notepad++ nay escape the backslash \ ? For example, if I save a . csv file with the content A\032 Notepad++ escapes backslash and interprets part…
-
1
votes0
answers1859
viewsMYSQL, problem with characters importing csv
I am passing the Maxmind csv database to mysql and some accented characters are giving problem. In Latin appears a ? and in UTF nothing appears. CSV : Östra Frölunda UTF8 : LATIN1: ?stra Fr?lunda I…
-
1
votes0
answers28
viewsUse xls as data source
I have several spreadsheets with data. They have the first column as table name. 1) You can format a CSV with the first column as the table name, instead of normally using the first row as the…
-
1
votes0
answers78
viewsBlock(reservation) of an auto increment line in mysql
I developed a data importer CSV to my base mysql. The Resource is working correctly, but I believe there must be a better way to implement the following logic. In the archive CSV depending or may…
-
1
votes1
answer1011
viewsProblem importing text file via VBA
I am trying to import a text file to excel through the following macro: Sub Teste() Dim intervalo As String intervalo = "intervalo" Workbooks.Add ActiveWorkbook.Sheets("Plan1").Select With…
-
1
votes0
answers153
viewsSelecting and deleting random lines from csv in python
I need to make a small script in python that meets the following requirements: Open a csv file; Delete first row and first column from reading as it contains information that will not be needed in…
-
1
votes0
answers68
viewsError while retrieving Web Service Object List (CSV)
I have an error retrieving a list of CSV objects from the server.. I’m using Jsefa to serialize and deserialize Java Beans for CSV and implemented a Messagebodywriter and Reader to make this…
-
1
votes1
answer63
viewsHow to merge several Excel tables into one?
I have 3000 tables like in this example: I need to merge them into one and I’m using the remote: =ÍNDICE(TXT!$B$1:$B$200,CORRESP(MAIOR(SE(TXT!$A$1:$A$200="Last…
-
1
votes1
answer114
viewsPass CSV content to an Sqlite table
I have a CSV file with student records. I would like to upload these records to a table aluno in the Sqlite. How can I perform this operation?
-
1
votes2
answers567
viewsAdd a fixed line to every 50 PHP CSV lines
I have a problem. I have a CSV file with 490 lines (on average this value can vary) and I would like to add 1 certain number to every 50 lines. Each line basically consists of 10 numeric digits and…
-
1
votes2
answers414
viewsInsert CSV file data into the pl/sql Database using VB.NET
I am reading a csv file by a Console Application, and up to this point is returning me correctly. Now I’m having trouble understanding how to include each field in a Bank column. This is the code I…
-
1
votes1
answer444
viewsReading CSV with Python
As I can go giving a "scan" in the CSV file and when finding certain String in the CSV line, print in another file the complete line with its values after the string. Ex When you find the string…
-
1
votes1
answer85
viewsDelete words from a file
I have a file CSV and I have this list of words here: https://gist.github.com/alopes/5358189 The archive CSV has 3 columns, Text, user.name and Class and has about 100K of rows. I need to delete…
-
1
votes1
answer598
viewsImport csv without duplicating records
I have a spreadsheet with 32000 records, and I need to play for a table in the database. The problem is that in this spreadsheet I don’t have the ID of the records and I can’t let it duplicate when…
-
1
votes1
answer421
viewsProblem using javascript, NODE JS and CSV database
Hello! I’m doing a project for the school using IBM’s Bluemix and am having some problems finding my mistake. I am using a database in CSV that has as parameters the neighborhood, number of rooms,…
-
1
votes0
answers58
viewsDate Filtered Crystal Reports Export (C# Mysql)
I have a Crystal Report object that is bringing the records of a View from a Mysql database. I need these records to be exported to a CSV file and I got this with the following code: private void…