Questions tagged as 'csv'

1
answer

Function export to Excel with PHP parameters

I want to adapt this function that I use to export the complete DB to Excel to a function that by passing a parameter (paq) I returned an excel with the matches of the DB. My HTML of the button. <button onclick="Export()" class="btn btn-...
asked by 27.07.2017 / 20:04
1
answer

How to call data in csv of date and time that are in the same column, to make a daytime cycle?

I am very new to this! I'm looking at a class called data analysis, where we are asked to perform a diurnal cycle of a time series that measures radiation per minute, but I have a file in csv where in a single column I have the date and time, as...
asked by 25.11.2016 / 18:27
2
answers

list index out of range when processing a csv file

This is the complete line of the CSV file where it gives the error: 21890;BH Telecom (PTT BiH, GSMBIH);Bosnia and Herzegovina If I send to print the variable split , it puts it here: 21890;BH Telecom (PTT BiH Where the comma begi...
asked by 12.05.2016 / 05:20
1
answer

Error Code: 1265. Data truncated for column 'Record_id' at row 1 0.109 sec

I have the "registry" table defined in this way in my database: create table registro( Id_registro int not null auto_increment, fecha date, financiero int not null, clientes int not null, procesos_internos int not null...
asked by 25.05.2016 / 03:54
1
answer

Iterate repeatedly on file parsed using csv.reader

I am trying to do a search filter of a tsv file, where the user enters the filters to visualize the data he wants to iterate over the file. The code that I am using is the following: import csv with open("results.tsv") as tsvF: reader = c...
asked by 04.04.2018 / 19:37
1
answer

Iterate repeatedly on file parsed using csv.reader

I am trying to do a search filter of a tsv file, where the user enters the filters to visualize the data he wants to iterate over the file. The code that I am using is the following: import csv with open("results.tsv") as tsvF: reader = c...
asked by 04.04.2018 / 19:37
0
answers

Concatenate several csv into one [closed]

I have the following code to concatenate several csvs in one only separating each one by a blank row in the final csv. But he is only able to catch the first csv without repeating the same action with the rest. Any idea how I could solve it? Tha...
asked by 23.04.2018 / 06:54
1
answer

PHP - Browse large CSV file with function

I've been looking for how to find a value on one line and return another value from another column on the same line in a CSV file. This is my function and works perfectly on small files: function find_user($filename, $id) { $f = fopen($...
asked by 28.08.2017 / 06:03
1
answer

Read a CSV in R, from another one generated by R

I explain my current situation, I want to be able to save a CSV file in one operating system and load it in the other without having to indicate the type of column. I explain why. When you have in R a data.frame style: data.frame(V1=c("1","2...
asked by 03.09.2018 / 17:11
1
answer

Python does not record sensor data in csv file

I'm doing a python tutorial with arduino, with an exercise that tries to record the data of two sensors: a motion sensor (digital input), and a potentiometer sensor (analog input). The problem I have is that although when I run the program it...
asked by 11.07.2017 / 10:18