Questions tagged as 'csv'

Tagged questions
1
answer

Error downloading awesome table files

Good evening; I write to see if the error is by the browser or is common in these cases. I'm developing a view using awesome table view, which allows you to interact with googlesite with googlesheets and allows you to download the filters wit...
asked by 13.11.2017 / 02:58
0
answers

error in excel data from a csv with epplus

I have a csv file that has as one of its data 829/10/17 and using epplus to convert to excel it changes to this data -390883 although I force the column to type text, and probe also in perzonalidad and general and keep doing it, could you help m...
asked by 31.10.2017 / 06:38
0
answers

How to extract data from a MYSQL query in .csv

Good afternoon, I'm trying to get the data from a query to a .csv file and I can not get it to work. Here I put my code. Thanks SELECT CAST(avg(numero) as decimal(18,2)) as media FROM ( SELECT DATE(fecha_creacion) fecha_creacion, COUNT(*)...
asked by 26.10.2017 / 17:13
1
answer

Save information in a csv without being repeated (php)

I am looking for a way to save variables in a csv file. Here is an example of what has been achieved: $enlace="http://php.net/manual/es/function.fgetcsv.php"; $Z = md5($enlace); $A = substr($Z,0,2); //Obtenemos los primeros 2 caracteres del...
asked by 03.10.2017 / 06:06
1
answer

Save files to a new python folder

folder = "C:\Users\Martin\Downloads\WL tags" df = pd.read_csv("Tags para Mandar WL.csv", header=0, sep = ",") for i, g in df.groupby('Inventory Name'): g.to_csv(folder, '{}.csv'.format(i.split('/')[0]), index=False) I want to save my cre...
asked by 04.10.2017 / 05:29
1
answer

Golang read a csv file of 144513 records concurrently

I am using the following file from the geonames database:    link The geographic database GeoNames covers all countries and contains more than eleven million place names that are available for download for free. The file has: 144...
asked by 29.08.2017 / 19:04
0
answers

Validate duplicate records when uploading CSV

What I need is to be able to upload a .CSV file, and if in the bd there is already a record with a duplicate RETURN and PROCESS number, I skipped a script saying that there is already a record with that number of the form and process . So far th...
asked by 10.07.2017 / 16:24
0
answers

Load of CSV erroneous

In this code I have a small example of how to load CSV: $message = ""; if (isset($_POST['submit'])) { $allowed = array('csv'); $filename = $_FILES['file']['name']; $ext = pathinfo($filename, PATHINFO_EXTENSION); if (!in_array($ext, $allowe...
asked by 29.06.2017 / 09:13
1
answer

Save data to a csv file

I need to save my data from the Rails database in a CSV file. I followed the steps in this post: link But when you do everything as you put it there, when opening in the browser I see this error: 500 Internal Server Error If you are t...
asked by 17.05.2017 / 12:00
1
answer

How to group grouped values by different date by a single value per hour

Good, I need to show the number of calls that are made every hour in a whole month. So far I was able to do a resample of the CSV so that I stayed as follows: Cantidad Fecha 2017-03-01 00:00:00 5 2017-03-01 01:00:0...
asked by 05.05.2017 / 01:25