Recent questions tagged CSV

0 votes

1.1k views

1 answer

csv - Loading UTF-8 file in Python 3 using numpy.genfromtxt

I have a CSV file that I downloaded from WHO site (http://apps.who.int/gho/data/view.main.52160 , Downloads, ... can I read the file into numpy? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

959 views

1 answer

csv - VBScript to loop through all files in a folder

I have the code to carry out the process on a single file, could anyone alter this script so it loops ... would be much appreciated! Thanks See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

csv - Python Pandas read_csv skip rows but keep header

I'm having trouble figuring out how to skip n rows in a csv file but keep the header which is the 1 row. ... header=0, skiprows=10, nrows=10) See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

977 views

1 answer

csv - Read specific columns with pandas or other python module

I have a csv file from this webpage. I want to read some of the columns in the downloaded file (the csv version can ... .08,K4III,1.56,4340.0,, See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

csv - What is the opposite of GROUP_CONCAT in MySQL?

I seem to come against this problem a lot, where I have data that's formatted like this: +----+------- ... do this? What is this kind of operation even called? Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

956 views

1 answer

csv to array in d3.js

I am using this to parse a csv file and create an array data as specified in d3 docs: d3.csv("afile.csv", ... . I need to reference data out of d3.csv() Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

912 views

1 answer

csv - How to load jar dependenices in IPython Notebook

This page was inspiring me to try out spark-csv for reading .csv file in PySpark I found a couple of posts such ... 0.3 but it is not supported. Please advise. Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

935 views

1 answer

csv - Regex for Comma delimited list

What is the regular expression to validate a comma delimited list like this one: 12365, 45236, 458, 1, 99996332, ...... Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

csv - Stop Excel from automatically converting certain text values to dates

Does anyone happen to know if there is a token I can add to my csv for a certain field so Excel doesn't ... date) within double quotes, but that has no effect. Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

csv - Python Pandas Error tokenizing data

I'm trying to use pandas to manipulate a .csv file but I get this error: pandas.parser.CParserError: ... module or another language ? File is from Morningstar Question&Answers:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

csv - Nested JSON with variable keys to TSV using jq

I have the following nested JSON file labs.json with variable keywords (lab001, lab002, etc.) which I would ... questions/65831692/nested-json-with-variable-keys-to-tsv-using-jq...