Questions tagged as 'csv'

Tagged questions
1
answer

Find equal values between 2 different .csv columns and update another column X

Hello, I have two .csv files as below: .csv1 POS,ID 28000167,. 28000263,. 28000484,. 28000711,. 28000728,. 28000885,. 28089922,. 28089927,. 28090173,. 28090325,. 28090326,. 28090331,. 28090415,. 28090467,. 28096247,. 28096264,. 28096284,...
asked by 02.03.2017 / 02:57
2
answers

How to count the number of rows in a .csv file

I'm trying to count the number of rows in a .csv file but giving error    Fatal error: Maximum execution time of 30 seconds exceeded in. <?php ini_set('max_execution_time', 300); class Teste{ public function contarLinhas($ar...
asked by 04.01.2018 / 15:26
2
answers

PHP script to open CSV files directly, with no need to submit formulas

I'm developing a PHP script for database upgrade. Basically I will schedule the execution of the script on the client machine (via the scheduler), it will open a URL on the server and perform the update of the database. On the server it has a...
asked by 25.01.2018 / 12:14
1
answer

How to open a csv created in Python without opening an import screen?

I have already created a csv in Python 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 within the csv defaults? Detai...
asked by 24.01.2018 / 16:40
1
answer

Failed to read .CSV file

Dear, I have the following code, where I read a .CSV file and show it in a table. It even does the proposed, however I get the error Notice: Undefined offset: 1 at the end of the file. This for all arrays, minus 0 How to resolve this e...
asked by 11.07.2018 / 21:50
1
answer

How to create dictionary from lists

How to associate lists with keys and values to create a dictionary in Python? Is the problem the following? I have a large csv file and I need to read the first line (make it into a list) that should be used to bind to the Keys and the follow...
asked by 12.05.2018 / 17:50
1
answer

Line break in PHP with CSV

Hello, friends! I have this CSV: AndthiscodeinPHP:<?php//Createatablefromacsvfile$area=0;echo"<table class=\"table table-hover\">\n\n"; $f = fopen("horarios_modificados.csv", "r", ";"); while (($line = fgetcsv($f)) !== false) {...
asked by 05.09.2017 / 20:23
2
answers

Turn IP number into location

I get a file in .csv with data from some users. NOME | E-MAIL | IP | DATA Location is missing. I would like to know if you have how to get the IP number and turn it into the location. There are services on the internet that inform the...
asked by 23.08.2018 / 17:00
1
answer

An object's data 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 toString() {...
asked by 25.11.2018 / 06:29
2
answers

Get CSV list with Python

I have a CSV file with more than 9000 lines. I need to get a list with just one die from each line. An example is as follows: 01/02/19,carlos,casa,rio 03/05/18,luis,carro,maceio 06/04/17,camila,celular,teresina I need to get a list with...
asked by 27.03.2018 / 02:57