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
-
0
votes1
answer95
viewsHow to read a previously built-in CSV file in the android app?
I’m having difficulties in getting this part , I’ve followed all the steps of various sites, I reach the end and the application reads the file. Does anyone know what might be happening??
csvasked 6 years, 5 months ago leandro lopes 11 -
0
votes1
answer1002
viewsImport decimal with comma
On SQL Server, I’m trying to run a SELECT in a *.csv file as follows: SELECT * FROM OPENROWSET(BULK 'C:\Minha_Pasta\meu_arquivo.csv', FORMATFILE = 'C:\Minha_Pasta\format.xml') AS Contents…
-
0
votes2
answers192
viewsRemove a CSV line by position - PHP
Hello.I have a form that generates a CSV file with the data entered by the user. The data saved in this csv is printed on the screen where a number is assigned for each line (1,2,3...). I needed the…
-
0
votes1
answer365
viewsHow to format cells in excel through php?
I have a php code that retrieves data in a database and generates a CSV file. The client opens this CSV in excel to view the data. So far so good. The demand of the client is that he wants to open…
-
0
votes1
answer146
viewsManipulation of CSV in R
I have several files with the extension . csv, I need to read them all, however I have a problem where I have the following variety of file. df1 -> Cabeçalho numérico antes do cabeçalho atual 1 2…
-
0
votes0
answers1066
viewsHow to change the CSV file field separator from ',' to ';'
I am developing a utility to transform XLS and XLSX files to CSV, but I would like CSV files to come out with semicolon separator instead of comma, here is the code: # -*- coding: iso-8859-1 -*-…
-
0
votes2
answers2072
viewshow to delete a column in a python csv file
How do I delete a column from a csv file? example: nome;nota;idade joao;10;12 maria;8;13 jose;6;8 to look like this: nome;idade joao;12 maria;13 jose;8 and how do I place a new column from that file…
-
0
votes1
answer78
viewsSame code producing distinct results in Codeenvy and Windows 8.1
I had made the following code in codevy.io and Python installed in codenvy is 3.5.1. I took this code and put to run in windows 8 with python 3.6.1. The purpose of the code is to clean some CSV…
-
0
votes1
answer175
viewsHow to open . csv file containing "ç" in column label with Python
I’m starting at the Python and I have a problem: I need to open a file .csv in the Python, but in the column header contains a ç. When I try to open it presents the following error:…
-
0
votes1
answer666
viewsWord processing in csv file
I have a database with over a thousand opinions (text) in a csv file, however I need only texts that contain more than 5 words to stay in my file. The problem is to make a code that goes through the…
-
0
votes1
answer156
viewsINTO OUTFILE command saves file without header, how to set header?
Good afternoon, everyone, I am running the following command to save files coming from MYSQL. Works however I cannot save the file with header, the data comes without header. SELECT * INTO OUTFILE…
-
0
votes1
answer202
viewsUnicodedecorror when reading CSV file
I am trying to read a CSV file in Python using: import csv import json arquivo = open('dados_teste.csv', encoding='utf8') texto = arquivo.read() resultado = json.loads(texto) print (resultado) But…
-
0
votes1
answer32
viewsHelp with condition to mount csv layout with php
I am generating a . CSV for an import where it is returning me the data as you can see in this gist: https://gist.github.com/otaciobarbosa/b1b442816ec95ff570d6d5c70e8b1f64 What happens is I have 2…
-
0
votes0
answers65
viewsPython - Send csv to database
I’m writing a script that joins all files of the same format into a folder and creates a single CSV and I want to send that CSV to the database. As new files enter this folder, CSV will always…
-
0
votes2
answers665
viewsLoad multiple concatenated CSV at once in Python
Talk personal, quiet? There is an easier way to load . csv concatenated at once instead of doing the procedure below? z1 = pd.read_csv('arquivo1.csv') z2 = pd.read_csv('arquivo2.csv') z3 =…
-
0
votes1
answer116
viewsconvert decimal and date to LOAD DATA INFILE
I am importing a CVS file into Mysql. I have two columns: a quantidade and the other as data. I am trying to convert to Mysql default. In the database this column is as decimal and date. You are…
-
0
votes1
answer221
viewsPostgresql - Importing . CSV into an existing table
I have a table with three columns, which already has data, in my Postgresql. I have a file . CSV with four columns. I would like to add the data of three columns of . CSV to SQL without replacing…
-
0
votes1
answer1202
viewsIs there a size limit on the writerow of csv?
I will create a CSV of 1,341 lines (with header). In Python 3 I used csv commands, but the file created has 1,282 lines The line data is extracted from 1,340 Pdfs, from the metadata. I created a…
-
0
votes1
answer98
viewsPython - Ignore Nan values in a . csv and add the rest
Hello, I have a file . csv that I am trying to pass to json Produtos Quantidade Bala 50 Refri NaN Salgado 25 And I’m importing for a json, wanted to know how to ignore the Nan values and return the…
-
0
votes1
answer259
viewsUpdate a CSV line without having to go through it all c#
Could I update a specific line of the CSV file? i have the information of which line I want to add information, currently I have the code that goes through the file and when it arrives in the line I…
-
0
votes1
answer39
viewsRun more than one csv file using python
I have the following question: I read a csv file and in this file I want to take the lines 0:9 and leave the 10 on. I made this code and everything seems to be ok. My problem is: How to read…
-
0
votes1
answer109
viewsFilter AD User - Powershell/CSV
Dear colleagues, I need to read a CSV file and filter the users within the AD with the information contained in the CSV. I need to compare the CSV field with the Userprincipalname inside the AD. My…
-
0
votes2
answers139
viewsSort equal rows
I have 4 columns in excel: A,B,C,D right? Only that I need to order to make a comparison because all the information is disorganized I explain myself: Original Archive in . CSV (Disorganized…
-
0
votes1
answer52
viewsError accessing Dictionary Code
I create a program to read from a file csv a set of coordinates and stores them in an object DataFrame. The code goes below df = pandas.read_csv(os.getcwd() + "/Coordinates.csv")…
-
0
votes1
answer88
viewsHow to treat columns with the same name in csv file
I have the following problem, I received a database in csv file and I need to analyze this data, but it has a lot of columns with the same name and I wanted to know if you have any way to treat…
-
0
votes0
answers38
viewsAccessing data in CSV
The code is to separate the values of each state in different lists, so the variable 'o' changes all once the state acronym changes and tells which list the values will be. It works until the…
-
0
votes1
answer43
viewsExport fopen without ""
I’m using the fopen , to export the return of a select, it is exporting correctly, more in certain fields this appearing "" as I remove the "" of export, leaving only the , because it’s coming out…
-
0
votes1
answer76
viewsSQL Plus - Export CSV without Query in File
I am trying to export the result of a query in SQL PLUS to a CSV. It is working, but I want used for extraction is coming in the first lines of the CSV file, which hinders the end user. Have some…
-
0
votes1
answer121
viewsEdit C. csv files
I need to make a programming code in C, in which I ask the user the name of a city, present in the first file (cities.csv), and I have to remove the id of the city inserted. Then this id has to…
-
0
votes0
answers62
viewsHow to import a . csv file to a Stored Procedure on SQL Server without using "BULK INSERT"?
I am trying to perform an SP that lists the . csv files in a folder via the command XP_CMDSHELL And then imports the files. csv for an auxiliary table in the database, but I do not have permission…
-
0
votes1
answer85
viewsOpen Python file in a different folder (Explorer)
I would like to know some way to open a file (example, a .csv to do some data analysis) from Windows Explorer. Example: arquivo = open('arquivo_1.csv','r') but with the file 'arquivo_1.csv' coming…
-
0
votes1
answer254
viewsI need to go through the data of several txt, take specific data and generate a csv
I’m already going through the files and accessing the data, but I need to get what’s after the following line: P.A.C.() initial P.A.C. () Sopave of the quota due 3a. installment due due due payment…
-
0
votes0
answers179
viewsDelete empty lines at the end of a CSV file with PHP
Hi, I need a tip, I was making an import of a file on CSV to change a record in my database and strangely could not do it, I did an analysis in the code in PHP and it’s all right so I left for the…
-
0
votes1
answer16
viewsDownload CSV file in WEB directory
I am trying to download a CSV file in the directory but it is downloaded in . TXT Unsuccessful attempts (PHP 7.1) header('Content-type: text/csv; charset=UTF-8') header("Content-Type:…
-
0
votes0
answers154
viewsSearch a C. csv file
Hello! I’m new to programming, and for a college job, I have to create a project where I have to use .csv. files.The program itself compiles, but I know I have an error in an if function, and I…
-
0
votes1
answer326
viewsHow do I change the csv header, C#
I’m generating a CSV file, but I’d like the header was the same as anottation displayname. When I export, the displayname is ignored. call of the method string csv = ListToCSV(resultado); private…
-
0
votes0
answers6
viewsOracle Apex upload data via csv file
I have a problem in my system, I have a demand where I need to implement a functionality to be possible preencher dados através de um arquivo csv, a company would create in Apex the records for the…
-
0
votes2
answers1669
viewsChanging the Python CSV File Delimiter
I have a difficulty in delimiting the cells of the CSV file, when I send the command to save the edited file in CSV escritor.writerow([linhas]) the default delimiter is ,, the more I need to change…
-
0
votes0
answers667
viewsExport 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…
-
0
votes1
answer90
viewsHow can I tabulate a mass file?
Hello, I have a 64500-line file and 11 tabular columns. The original file came from the counter system, which is a system for printing paper. I already got the headlines out, but I’m having trouble…
-
0
votes1
answer503
viewsRead exact csv php columns
I’m reading csv this way: $handle = fopen($file, "r"); while ($data = fgetcsv($handle, 1000, ",")) { if($row !== 0) { $dados = explode(";", $data[0]); $VALOR_1 = utf8_encode($dados[1]); $VALOR_2 =…
-
0
votes1
answer116
viewsI need to read a . csv file and rewrite it into another . csv file without stopwords using Python
from nltk.corpus import stopwords from nltk.tokenize import word_tokenize from string import punctuation import csv texto = open('arquivo_sujo.csv','r').read() with open('arquivo_limpo.csv', 'w') as…
-
0
votes1
answer237
viewsFind a sub-string in the first column of a csv file
I am starting learning in python and do not know how to continue this code. I need to check the first column of a csv file, and if I don’t have a date in a cell in that column, insert the one that…
-
0
votes2
answers110
viewsOutput not expected in CSV Python (infinite loop) file
Bom, I’m trying to save the distance and time, result of the difference in the sending/arrival time of the ultrasonic sound, this through the sensor for Raspberry Pi 3 HC-SR04! After obtaining these…
-
0
votes0
answers211
viewsRemove quotes when uploading csv
I did the following instruction to upload a csv to the database: public void importarBaseBruta(File arquivo) { try { this.limparBaseBruta(); this.con.conectar(); this.stm = this.con.getStm();…
-
0
votes1
answer906
viewsHow to perform calculations on top of a CSV file with Python 2.7?
I am learning some commands for analyzing data extracted from a CSV file and locked in the following situation: I want to use as a basis this CSV to realize the average of the room: Nome;P1;P2;P3…
-
0
votes1
answer583
viewsImport CSV into Django database
I have a CSV database and wanted to import to my models from Django, CSV has this structure: NAME,CLUB,LEAGUE,POSITION,RATING,PACE,SHOOTING,PASSING,DRIBBLING,DEFENDING,PHYSICAL,LOADDATE Tore…
-
0
votes3
answers93
viewsPopular table in page loading
Hello. I am creating a page of registration of people, every click on the save button is generated a csv file that the next page load should be used to show on the screen the already made entries,…
-
0
votes1
answer242
viewsWrite to csv file
I have a function that returns a line and this should be inserted in a CSV file. The line has the following structure when returned by the function: ['x' - 'y', 'z', ['a', 'b', 'c', 'd', 'e', 'f']].…
-
0
votes2
answers529
viewsAvoid double quotes in CSV file exported with PHP
It is possible to prevent the file CSV come with aspas duplas in string fields, I am using the script below, but the field nome is coming between aspas duplas, how can I avoid this? <?php…