Questions tagged as 'csv'

Tagged questions
0
answers

Increase the value of a column in a .csv file using php

I'm looking for some explanation or help on how to solve this problem: $s ='1245'; $f = fopen(__DIR__ .'/datos/saved.csv', 'r'); $result = false; while ($row = fgetcsv($f, 0, ',')) { if ($row[0] == $s) { $result = $row[2];...
asked by 05.10.2017 / 02:16
1
answer

Error pandas and matplotlib could not convert string to float

I'm trying to draw on a graph the cell phone prices according to their models For now I have this import pandas as pd import csv import matplotlib.pyplot as plt import matplotlib.dates as mdates df1 = pd.read_csv('MercadoLibreMejor_items.c...
asked by 25.07.2017 / 18:58
1
answer

I can not convert a Json format into a csv table

I tried to convert a json to csv, I tried it directly with the library csv and also with pandas , but it tells me TypeError . This is my code: import urllib2, json url = "https://www.ncdc.noaa.gov/cdo-web/api/v2/stations"...
asked by 29.06.2017 / 07:39
0
answers

SQL field contains FieldTerminator

A BULK INSERT is made from a CSV file as seen below: BULK INSERT [bdc_sync_L].[dbo].[Libro_bibliografia] FROM 'D:\Data Center\Archivos\PRUEBA.csv' WITH(FIELDTERMINATOR = '|', ROWTERMINATOR = '\n') The problem is that a record has t...
asked by 08.06.2017 / 18:22
2
answers

How can I compress into a .zip file and then delete the original files

I have a program that calls a stored procedure which works well. The result of this, gives me 10 files with the name of the different projects. What I'm trying to do is to be able to compress those 10 files and make a single .ZIP file that...
asked by 18.08.2016 / 18:10
1
answer

How to import a csv file in Cassandra?

Good afternoon, I try to import a csv file in Cassandra that is very long. It is dealing with food products: ingredients, nutrition, labels. It comes from Open Food Facts. It lists information about food products: ingredients, nutritional inform...
asked by 22.11.2017 / 14:02
1
answer

Help with my converter to csv

I am doing a converter of xsl and xlsx to csv but I am having problems with the dates. When a date comes to me in one of the cells, does not it remain in dd/mm/yyyy , if not change it to mm/dd/yyy , any solution?...
asked by 30.05.2018 / 07:45
1
answer

It seems that Git already took into account the files added in .gitignore

I do not want to add .csv files in my repositiorio github so I've written in .gitignore : # Compiled source # ################### *.csv But I answered the terminal: mike@mike-thinks:~/Data/on_2018_04_25_16_43_17$ git push ori...
asked by 15.05.2018 / 17:33
1
answer

How to group multiple columns and count records with LINQ from a CSV file in C #

I have a problem grouping several columns and counting your records in each column by reading it from a CSV file, Example CSV records: Nombre,Apellido,FechaDeRegistro,Aceptado David,tod,09/09/2014,SI David,lopez,09/09/2011,NO David,cortez,09/0...
asked by 07.12.2016 / 15:31
1
answer

It is possible to define the destination path when saving a .csv file in python3.XX

Without needing to open a .csv file, I need to generate a new csv document. and when scheduled to be saved, it is hosted on a destination path defined by the user.     
asked by 23.02.2018 / 17:28