Category "csv"

Creating undirected weighted graph from adjancency matrix from a csv

I want to create undirected weighted graph of a given adjacency matrix by reading it from a csv. I can read it from a csv but I don't know how to draw its in gr

Way to convert dbf to csv in python?

I have a folder with a bunch of dbf files I would like to convert to csv. I have tried using a code to just change the extension from .dbf to .csv, and these f

Is there a way to save Cloudlet output to a csv file?

I'm working on a project using CloudSim simulation tool for masters. I want to know how to save the output of the printCloudletList to a csv file in NetBeans. A

Write single CSV file using spark-csv

I am using https://github.com/databricks/spark-csv , I am trying to write a single CSV, but not able to, it is making a folder. Need a Scala function which wil

How to read .csv with a compound header into a xarray DataArray (using pandas)

Given a dataset with the following structure: time var1 var2 var2 var1 var3 loc1 loc1 loc2 loc2 loc1 1 11 12 13 14 15 2 21

How to read .csv with a compound header into a xarray DataArray (using pandas)

Given a dataset with the following structure: time var1 var2 var2 var1 var3 loc1 loc1 loc2 loc2 loc1 1 11 12 13 14 15 2 21

Python Error io.UnsupportedOperation: not readable

i have this error and i don't know why i got it. I followed the steps from my Python manual and i got this. I am tryng to cleanup the file on column 8 and 9 if

SQL Server - join rows into comma separated list

Let's suppose I have a temporary table which looks like this: +----+------+ | Id | Value| +----+------+ | 1 | 1 | | 1 | 2 | | 1 | 3 | | 2 |

Read CSV starting with string from Zipfile

I'm trying to loop through a folder that has zip files in it, and only extracting the csv files that start with a certain prefix. Here is the code: for name in

Write csv to google cloud storage

I am trying to understand how to write a multiple line csv file to google cloud storage. I'm just not following the documentation Close to here: Unable to rea

String previous last index

Is there a simple way of getting the penultimate delimited substring of a string? String original = "/1/6/P_55/T_140"; In this example, the resulting substri

Python 'utf-8' codec can't decode byte 0xe0

import re dictionary = dict() for line in open('Group14.csv', encoding="utf8"): line = line.strip() date = re.findall('(\w+\s\w+\s\d+)\s\d+\S\d+\S\d+

Python pandas DataFrame from first and last row of csv

All - I am looking to create a pandas DataFrame from only the first and last lines of a very large csv. The purpose of this exercise is to be able to easily g

How to run XUnit test using data from a CSV file

Is there a way to run a data driven XUnit test using a CSV file as the data source? I've tried Cavity.Data.XUnit, but it's no longer compatible with the newest

jq convert to csv with keys to column rows

I have JSON example like this { "server1": { "dhcp-libs": "12:4.2.5-83.el7.centos.1", "perl-Time-Local": "1.2300-2.el7", "kbd-legacy": "1.15.5-15.

Python script to read multiple excel files in one directory and convert them to .csv files in another directory

I am relatively new to python and Stackoverflow but hoping anyone can shed some light of my current problem. I have a python script that takes excel files (.xls

TextFieldParser ignoring header row C#

Reading in CSV files and the TextFieldParser skips the header row. Any idea how to make certain the first row is skipped. String[] Col3Value = new string[40];

Python - String.split() using delimiter ',', but there is price in string also using comma in thousand

I am trying to use Python to parse a CSV file. I have a string like this: "11/11/14","Buy","1,900","$10.40","-$19,760.00" I want to parse it to into list

Read separately zipped csv file (.zip .z01 etc) over Python zipfile library

How could we read csv file which is zipped into multiple files? Due to the 4 GB limit of FAT storage format, I have complied csv file into multiple zip files l

Loop not working for urls from csv file

Here, the loop not working, only the first url from the csv file is working.I want to run this for all the urls in the csv file, can anyone help me please... M