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
votes4
answers1444
viewsExcel transpose row to column and preserves columns and replicate them in row
Hello, Next, I have a CSV as follows: A;B;C;D;1;2;3;4;5 E;F;G;H;6;7;8;9;10 The columns of letters have a regular structure, whereas the columns of numbers do not but you could blow them up and put…
-
1
votes1
answer4275
viewsRead CSV file ,Columns
I would like to know how to read a CSV file taking the first and second column and compare the string contained in it with another string I want in the code. Ex.: if(o conteudo do csv coluna…
-
1
votes1
answer60
viewsError showing data in Highstock chart
I have a chart Highstock in which I create a CSV coming from my database to then show this data on the chart, but it turns out that the graph only recognizes the CSV if after the CSV is created and…
-
1
votes1
answer932
viewsIssue with importing CSV into Mysql
I am importing csv file information into mysql database some spreadsheets were imported correctly, however some worksheets when importing to the bank appear a double quotes that does not exist in…
-
1
votes0
answers353
viewshow to validate a number of columns of a csv file in php?
I’m making upload with a load data infile in php. Nesse upload would need to validate the amount of columns that have the file .csv. If the amount is different from the amount coming from the bank…
-
1
votes1
answer46
viewsDjango csv error
Well, I have a problem reading csv and entering the data. I believe it is in Foreign key. The code is: View: def csvAih(request): coluna = 1 mes = 1 ano = 2008 while (ano < 2017): with…
-
1
votes2
answers1027
viewsHow to count the number of lines in a file. csv
I’m trying to count the number of lines a file . csv but giving error Fatal error: Maximum Execution time of 30 Seconds exceeded in. <?php ini_set('max_execution_time', 300); class Teste{ public…
-
1
votes3
answers810
viewsMultiple lines on a Showmessage in Delphi
I need to trigger an error message if the user tries to enter invalid codes in a temporary table on grid. The codes come from a .txt. The codes fired on the monitor are ok but the message is…
-
1
votes0
answers528
viewsHow to export a postgres table with column names to csv format with jdbc?
This is my code, which unfortunately does not export column names: package net.viralpatel.java; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import…
-
1
votes2
answers4274
viewsExport table (in pd.Dataframe) to csv - Python format
are fine? How to export or save a table made with pandas.Dataframe in csv or xlsx format in Python?
csvasked 6 years, 10 months ago Daniel Melo 33 -
1
votes2
answers187
viewsTurn IP number into location
I get a file on .csv with data from some users. NOME | E-MAIL | IP | DATA There’s no location on it. I wonder if there’s any way I can get the IP number and turn it into the location. There are…
-
1
votes1
answer714
viewsCSV In Ruby - Doubt
Good afternoon guys, I’m having a little trouble understanding how Ruby works with csv, I need to read a file and import the data from that file into a variable I have a file called given.txt like…
-
1
votes1
answer1160
viewsFind equal values between 2 columns of . csv and refresh another column X
Hello, I have two files . csv as below: .csv1 POS,ID 28000167,. 28000263,. 28000484,. 28000711,. 28000728,. 28000885,. 28089922,. 28089927,. 28090173,. 28090325,. 28090326,. 28090331,. 28090415,.…
-
1
votes1
answer1113
viewsCompare all Rows and Columns of two Df, update and add differences at the end of Rows and Columns
I have two csv separated by tab. Both have the same number of Rows and Columns. The first column POS has the same Unique values in both df. Differences (or not), occur in the values (strings) of the…
-
1
votes1
answer446
viewsSelect a row where a column has an element of a CSV
I have a table in the database with the following structure: +---------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra |…
-
1
votes1
answer389
viewsProblem concatenating csv files
I’m trying to concatenate one CSV file with another. My goal is to remove data from an HTML daily and my routine should take a csv file called 'old data' where there is a dataframe saved in csv, and…
-
1
votes0
answers41
viewsHow to convert a CSV file to HDF5 without code required, is it possible?
I need to convert a file .csv in hdf5 to use on RapidMiner to create templates. However, I have been searching and only find solutions using Python and other programming languages. As I have no…
-
1
votes0
answers885
viewsDistance table google maps api and python
Hello, I am using the Google Maps API to check the distance between two points, for this I have two local.csv files and coordinators.csv. The ultimate goal is to know the distance of the locations…
-
1
votes0
answers42
viewsData import error in R
Hello! I imported a base I requested via LAI for R. They sent me in excel, but I converted it into csv by working facilities. I know that when transforming all data from "character" columns to…
-
1
votes1
answer242
viewsHow to group numeric sequences?
Friends, I have a csv file with 5k lines in which there are purchase transactions. There is an id for each purchase, it occurs that for a lot where several purchases transactions are made there is…
-
1
votes1
answer439
viewsFilters in TXT file
https://drive.google.com/open?id=1ud743B57XM_iZ_wvQrSYGRrMo-5nT94p I have a file txt that I have to apply a filter to bring me a field in column 2. And then save the result in csv, so it’s easier to…
-
1
votes2
answers399
viewsRemove the last comma from an array of a While
I’m trying to remove the last comma from an Array but I’m not getting it. I have a CSV file in which I read and remove an array with a code to be used in a Where of a Query sql. I’m using…
-
1
votes1
answer2425
viewsPython -> how to merge multiple csv files
I have 4 folders, and each of them is filled with csvs of 3 types (ap,peers,visits). I’m a beginner in python, but I wanted to create a python script that would merge the files that are peer, in…
-
1
votes1
answer184
viewsCreation of empty csv
hello on the python code below, I want to create a csv with the sum of inhabitants in each state but it creates an empty csv file please, someone has idea of the problem? the original csv file in…
-
1
votes1
answer2240
viewsError reading CSV: A non well Formed Numeric value encountered
I am trying to take 3 different values from 3 distinct csv file and multiply them, but it is giving this error. Where did I go wrong? Or what’s left to add?! Error: Notice: A non well Formed Numeric…
-
1
votes1
answer972
viewsLine breaking in PHP with CSV
Hello, my friends! I have this CSV : And this code in PHP: <?php // Create a table from a csv file $area = 0; echo "<table class=\"table table-hover\">\n\n"; $f =…
-
1
votes1
answer41
viewsSave results of a query in csv - Hortonworks Hive
Please, I tried the code below on Hive 1.2.1000.2.6.5.0-292 and there was an error. How can I extract data from a query in a csv without creating a table? hive --e 'select * from product limit 10;'…
-
1
votes1
answer895
viewsDelete last line - Java
I’m reading a CSV using Bufferedreader by reading line by converting the result into a .txt. At the end of my txt is generating a line break after the last item. I’m trying to find a way to remove…
-
1
votes1
answer954
viewsArchive *.CSV with UTF-8
I created a process that takes the content of a given web page filters what is needed and generates a file *.csv of this content, you work correctly but words that have some accentuation end up…
-
1
votes1
answer388
viewsHow to increase upload size in php?
Good morning, I need to upload a csv file that is larger than the standard php that is 2M (the file is around 10 to 15M) The application works perfectly for files smaller than 2MB. I’ve tried in…
-
1
votes2
answers141
viewsAddition of columns in csv file - Python
I’m not able to create a csv file with a new column (month). When I try to create the whole column is only with the month of December(12) but the month column should correspond to the whole number…
-
1
votes0
answers306
viewsSet file cell *.CSV as merged
Is it possible for a given cell to be merged into a generated *.csv file? I ask because I am generating a *.csv file where the user should only do one Ctrl + C \ Ctrl + v in the content and paste in…
-
1
votes2
answers1480
viewsComparison of elements from a JAVA list
I would like you to shed some light on that exercise. I need to print on the console the name and price of the two most expensive products read from a file .csv but it is only printing the last name…
-
1
votes3
answers2116
viewsCreate table csv in python
I’m trying to build a table from information collected on a website. The problem is that although the print comes out as expected, at the time of saving in csv file is going only the last record.…
-
1
votes1
answer130
viewsHow to open a csv created in Python without opening an import screen?
I have created a Python csv in several ways as can be seen below, but every time I open the file opens the import screen as below. Why does this happen? And how can I make the file open directly,…
-
1
votes2
answers344
viewsPHP script to open Csvs files directly, no need for fomulário sending
I’m developing a PHP script for database update. Basically I will schedule the execution of the script on the client machine (via scheduler), it will open a URL on the server and will perform the…
-
1
votes2
answers355
viewsGet CSV list with Python
I have a CSV file with more than 9000 lines. I need to get a list with only one data of each line. An example is the following: 01/02/19,carlos,casa,rio 03/05/18,luis,carro,maceio…
-
1
votes0
answers25
viewsCSV import (which is inside a zip) automatically received by email to the Spreadsheet
What happens is that every day I receive an email with a report attached. This attachment is zipped(.zip), and inside this zip has a CSV file. I need this zip to be converted to CSV and this CSV to…
-
1
votes1
answer520
viewsFormat csv via php
I have the following code, where it generates a csv spreadsheet. <?php require_once ('dbacess.php'); // output headers so that the file is downloaded rather than displayed header('Content-Type:…
-
1
votes1
answer641
viewsHow to create dictionary from lists
How to associate lists to keys and values to create a dictionary in Python? Is that the problem? I have a large csv file and I need to read the first line (I turn it into a list) that should be used…
-
1
votes0
answers64
viewsValue duplication when importing file . csv when one or more column(s) is missing from the file
When I import a . csv file to save to the database and the file is missing the name of some column instead of inserting null in the bank it repeats the value of the first column. Following example;…
-
1
votes0
answers191
viewsCSV file via FTP automatically
Dear, I have a doubt, I have a script in php that already creates a CSV file for the machine itself. I need this CSV to be sent to an FTP automatically daily, however I am not able to think of the…
-
1
votes1
answer71
viewsFailed to read file. CSV
Dear, I have the following code, where I read a file . CSV and show it in a table. It even does the proposed, however returns me the error Notice: Undefined offset: 1 at the end of the file. This…
-
1
votes1
answer114
viewsExport password protected csv from a DB
It is possible to generate a file CSV protegido por Senha from a banco MySql using PHP? the password is to open the file in the client. I use this PHP script to generate the CSV file: <?php…
-
1
votes1
answer849
viewsHow to "clean" a csv file with Python?
Hello! I’m extremely new to programming, so I apologize if I can’t explain what I’m trying to do or if my code is really wrong. I have a recurring task in my job which is to open a list of…
-
1
votes1
answer192
viewsWrite ; in . CSV without separating the cell
I have a C# project that is normally generating a file with extension. CSV, however I want to write a ;(point and comma) but it does is to separate the cell. There is some way to write without that…
-
1
votes2
answers1146
viewsSave html form input in csv
I created a form in html where the user type the name, email, phone, but I need to redeem these "entries" in csv for future firing email. Can someone give me a hand on how to feed this csv with…
-
1
votes1
answer122
viewsData from an object is null after reading from a CSV
I have the following Java class: public class Pessoa { private String employee_name; private String user_id; private String domain; private String email; private String role; @Override public String…
-
1
votes1
answer132
viewssearching data in csv file with Javascript
I’m researching a solution to a problem and I haven’t found anything I could understand, so far, I have a csv file that contains the data in this format: 0111-3/01,"Cultivation of rice" On the left…
-
1
votes0
answers65
viewsImport excel table directly into mysql
I’m using the following code to try to import 30,000 csv records into a comic mysql on the hostgator server load data local infile 'public_html/empresa.csv' into table empresa fields terminated by…