# Data

**URL:** https://discourse.julialang.org/c/domain/data/16.md?page=24

[Latest](https://discourse.julialang.org/latest.md) · [Categories](https://discourse.julialang.org/categories.md) · [Tags](https://discourse.julialang.org/tags.md)

**Page:** 25

---

## [Delete!() row from DataFrame incompatible with CSV.jl?](https://discourse.julialang.org/t/delete-row-from-dataframe-incompatible-with-csv-jl/39835)

<div class="topic-metadata">

**Author:** [@Fred](https://discourse.julialang.org/u/Fred)\
**Replies:** 3\
**Last updated:** [May 20, 2020, 2:43pm UTC](https://discourse.julialang.org/t/delete-row-from-dataframe-incompatible-with-csv-jl/39835 "2020-05-20T14:43:59Z")

</div>

Hi ! Following some packages updates, the functions I add used to delete rows in dataframes, such as deleterows!(), have been deprecated and I try to make my old code running again but I face a difficult problem. When …

---

## [RDataset: Error while running examples](https://discourse.julialang.org/t/rdataset-error-while-running-examples/39255)

<div class="topic-metadata">

**Author:** [@v-i-s-h](https://discourse.julialang.org/u/v-i-s-h)\
**Replies:** 2\
**Last updated:** [May 11, 2020, 11:59am UTC](https://discourse.julialang.org/t/rdataset-error-while-running-examples/39255 "2020-05-11T11:59:01Z")

</div>

Hi, I am trying to use RDatasets. In the github README, the following code is given as an example using RDatasets iris = dataset("datasets", "iris") neuro = dataset("boot", "neuro") But I’m getting the following error…

---

## [Audio issues on DataFrames tutorials?](https://discourse.julialang.org/t/audio-issues-on-dataframes-tutorials/39081)

<div class="topic-metadata">

**Author:** [@nickeubank](https://discourse.julialang.org/u/nickeubank)\
**Replies:** 1\
**Last updated:** [May 8, 2020, 1:06pm UTC](https://discourse.julialang.org/t/audio-issues-on-dataframes-tutorials/39081 "2020-05-08T13:06:50Z")

</div>

I’m delighted to see that JuliaLang is posting some DataFrames materials, and will have a Q&A later today! However, both this new video and the last set of DataFrames tutorials have some major audio issues. Any chance t…

---

## [Nearest Neighbor Search for points consisting of vectors/arrays](https://discourse.julialang.org/t/nearest-neighbor-search-for-points-consisting-of-vectors-arrays/38893)

<div class="topic-metadata">

**Author:** [@FrootLoops](https://discourse.julialang.org/u/FrootLoops)\
**Replies:** 4\
**Last updated:** [May 6, 2020, 9:46pm UTC](https://discourse.julialang.org/t/nearest-neighbor-search-for-points-consisting-of-vectors-arrays/38893 "2020-05-06T21:46:45Z")

</div>

Hello everybody, I am trying to use the nearest neighbor package in Julia. I read the documentary and it was very easy to understand the examples for one dimensional problems. In my case it is a little bit more complica…

---

## [Tables.jl: columntable to rowtable](https://discourse.julialang.org/t/tables-jl-columntable-to-rowtable/36112)

<div class="topic-metadata">

**Author:** [@aplavin](https://discourse.julialang.org/u/aplavin)\
**Replies:** 6\
**Last updated:** [May 4, 2020, 7:58pm UTC](https://discourse.julialang.org/t/tables-jl-columntable-to-rowtable/36112 "2020-05-04T19:58:01Z")

</div>

I’m trying to implement an interface to a column-based table storage backend, but struggle to make it work efficiently. The minimal implementation looks like this: import Tables struct MyTable \<: Tables.AbstractColumns…

---

## [DataFrames, aggregate with missings](https://discourse.julialang.org/t/dataframes-aggregate-with-missings/38737)

<div class="topic-metadata">

**Author:** [@donquicote](https://discourse.julialang.org/u/donquicote)\
**Replies:** 2\
**Last updated:** [May 4, 2020, 3:25pm UTC](https://discourse.julialang.org/t/dataframes-aggregate-with-missings/38737 "2020-05-04T15:25:45Z")

</div>

Hi! I’m facing the following problem: using DataFrames, Statistics df = DataFrame(A = \[1, 2, missing, missing, missing, 3, 4, 5\], B = \[1, 1, 2, 2, 3, 3, 4, 4\]) df\_mean = aggregate(df, :B, x -\> mean(sk…

---

## [JuliaDB documentation down?](https://discourse.julialang.org/t/juliadb-documentation-down/38703)

<div class="topic-metadata">

**Author:** [@clibassi](https://discourse.julialang.org/u/clibassi)\
**Replies:** 2\
**Last updated:** [May 4, 2020, 2:43am UTC](https://discourse.julialang.org/t/juliadb-documentation-down/38703 "2020-05-04T02:43:25Z")

</div>

Hi all, Been trying to do some work with memory that is too large for my computer’s memory and so have turned to testing out what I understand to be JuliaDB’s strength in this context, but as I went to read up on it I k…

---

## [\[ANN\] DataFrameDBs.jl](https://discourse.julialang.org/t/ann-dataframedbs-jl/35718)

<div class="topic-metadata">

**Author:** [@waralex](https://discourse.julialang.org/u/waralex)\
**Replies:** 60\
**Last updated:** [May 2, 2020, 3:09pm UTC](https://discourse.julialang.org/t/ann-dataframedbs-jl/35718 "2020-05-02T15:09:59Z")

</div>

Hi all! Julia is my hobby and I had some free time for the last 4 weeks, so here is the first results of my experiments GitHub - waralex/DataFrameDBs.jl: The DateFrameDBs is the prototype of persistent, space efficient …

---

## [DataFramesMeta.jl and the state of the DataFrames ecosystem](https://discourse.julialang.org/t/dataframesmeta-jl-and-the-state-of-the-dataframes-ecosystem/36221)

<div class="topic-metadata">

**Author:** [@jmboehm](https://discourse.julialang.org/u/jmboehm)\
**Replies:** 36\
**Last updated:** [April 24, 2020, 1:18pm UTC](https://discourse.julialang.org/t/dataframesmeta-jl-and-the-state-of-the-dataframes-ecosystem/36221 "2020-04-24T13:18:34Z")

</div>

Hi all, I’m currently working on a small package that’s supposed to make data wrangling easier (i.e. providing macros for commonly-used operations). As part of that, I’ve found DataFramesMeta.jl quite useful (in particu…

---

## [Yet another piping idea](https://discourse.julialang.org/t/yet-another-piping-idea/37597)

<div class="topic-metadata">

**Author:** [@pdeffebach](https://discourse.julialang.org/u/pdeffebach)\
**Replies:** 3\
**Last updated:** [April 21, 2020, 8:27pm UTC](https://discourse.julialang.org/t/yet-another-piping-idea/37597 "2020-04-21T20:27:14Z")

</div>

With the upcoming DataFrames 1.0 release and the new select and transform functions, piping will become much idiomatic in basic DataFrames usage, i.e. using DataFrames, Lazy julia\> @\> df begin transform(:b =\> (x …

---

## [Regridding 3d array](https://discourse.julialang.org/t/regridding-3d-array/37349)

<div class="topic-metadata">

**Author:** [@asb](https://discourse.julialang.org/u/asb)\
**Replies:** 1\
**Last updated:** [April 10, 2020, 5:37pm UTC](https://discourse.julialang.org/t/regridding-3d-array/37349 "2020-04-10T17:37:32Z")

</div>

nub question. I have a 3d array of input data1 of dimensions \[nx,ny,nz\] The data represent a 3D continuous function sampled on an irregular grid. data\[i,j,k\] is the data at grid point \[i,j,k\]. xgrid1\[i,j,k\] are the x…

---

## [JSON3 loading recursive structures](https://discourse.julialang.org/t/json3-loading-recursive-structures/37283)

<div class="topic-metadata">

**Author:** [@racinmat](https://discourse.julialang.org/u/racinmat)\
**Replies:** 0\
**Last updated:** [April 9, 2020, 3:08pm UTC](https://discourse.julialang.org/t/json3-loading-recursive-structures/37283 "2020-04-09T15:08:36Z")

</div>

Hi, I see that GitHub - quinnj/JSON3.jl can be used for writing and reading data to custom structures, specifically from this package https://github.com/pevnak/JsonGrinder.jl/tree/master/src/extractors. I want to use it…

---

## [Getfield with Measurements -\> access to undefined reference](https://discourse.julialang.org/t/getfield-with-measurements-access-to-undefined-reference/37159)

<div class="topic-metadata">

**Author:** [@MartinOtter](https://discourse.julialang.org/u/MartinOtter)\
**Replies:** 1\
**Last updated:** [April 7, 2020, 1:24pm UTC](https://discourse.julialang.org/t/getfield-with-measurements-access-to-undefined-reference/37159 "2020-04-07T13:24:46Z")

</div>

In this test model, an unexpected error is raised from getfield(…) when applied on an uninitialized struct on a field of type Measurements, and I do not find the reason: module Test\_getfield using Measurements mutable…

---

## [Trouble making a pivot table](https://discourse.julialang.org/t/trouble-making-a-pivot-table/36610)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 19\
**Last updated:** [March 30, 2020, 1:21pm UTC](https://discourse.julialang.org/t/trouble-making-a-pivot-table/36610 "2020-03-30T13:21:00Z")

</div>

df1 = DataFrame(XLSX.readtable("C:/Users/Brett/Documents/Soc332Assignment3.xlsx","TestData")...) #change everything to Float64 for name in names(df1) df1\[!, name\] = identity.(df1\[:, name\]) end #change everythin…

---

## [DataFrame by new columns containing arrays](https://discourse.julialang.org/t/dataframe-by-new-columns-containing-arrays/36614)

<div class="topic-metadata">

**Author:** [@yakir12](https://discourse.julialang.org/u/yakir12)\
**Replies:** 13\
**Last updated:** [March 29, 2020, 1:59pm UTC](https://discourse.julialang.org/t/dataframe-by-new-columns-containing-arrays/36614 "2020-03-29T13:59:45Z")

</div>

In DataFrames we can do this: by(iris, :Species, \[:PetalLength, :SepalLength\] =\> x -\> (a=mean(x.PetalLength)/mean(x.SepalLength), b=sum(x.PetalLength))) 3×3 DataFrame │ Row │ Species │ a │ b …

---

## [Where can I get detailed longitudinal data of the COVID-19 pandemics?](https://discourse.julialang.org/t/where-can-i-get-detailed-longitudinal-data-of-the-covid-19-pandemics/36577)

<div class="topic-metadata">

**Author:** [@Juan](https://discourse.julialang.org/u/Juan)\
**Replies:** 4\
**Last updated:** [March 27, 2020, 4:56pm UTC](https://discourse.julialang.org/t/where-can-i-get-detailed-longitudinal-data-of-the-covid-19-pandemics/36577 "2020-03-27T16:56:32Z")

</div>

Where can I download a full dataset of the SARS-CoV-2 pandemics containing time information for each individual (date of infection, date of death, age, gender, weight, censoring information…) It’s important to get this …

---

## [Add a column to XLSX](https://discourse.julialang.org/t/add-a-column-to-xlsx/36414)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 0\
**Last updated:** [March 24, 2020, 3:29am UTC](https://discourse.julialang.org/t/add-a-column-to-xlsx/36414 "2020-03-24T03:29:44Z")

</div>

I was trying to add a dataframe of 7 float64 numbers to an XLSX using XLSX.writetable!(sheet, columns, labels, anchor\_cell=XLSX.CellRef("B2")) Do I have the formating right? I think I might need to change the numbers t…

---

## [Error opening too many connections](https://discourse.julialang.org/t/error-opening-too-many-connections/29371)

<div class="topic-metadata">

**Author:** [@xiaodai](https://discourse.julialang.org/u/xiaodai)\
**Replies:** 5\
**Last updated:** [March 19, 2020, 11:46pm UTC](https://discourse.julialang.org/t/error-opening-too-many-connections/29371 "2020-03-19T23:46:19Z")

</div>

I am trying to write a parallel algorithm to write to many files. Is there a way to detect how many connections I can open? Or a way to rate limit my code? ios = open.( "file".\*(1:3000), Ref("w"), ) gives error ERROR:…

---

## [Get on GroupedDataFrame](https://discourse.julialang.org/t/get-on-groupeddataframe/36108)

<div class="topic-metadata">

**Author:** [@Marc.Cox](https://discourse.julialang.org/u/Marc.Cox)\
**Replies:** 11\
**Last updated:** [March 18, 2020, 11:43pm UTC](https://discourse.julialang.org/t/get-on-groupeddataframe/36108 "2020-03-18T23:43:25Z")

</div>

Issue using the Base.get Get a group based on the values of the grouping columns example code here \>\> Functions · DataFrames.jl Base.get — Function. get(gd::GroupedDataFrame, key, default) Get a group based on the va…

---

## [Problem changing Variables from Any to Real](https://discourse.julialang.org/t/problem-changing-variables-from-any-to-real/36116)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 10\
**Last updated:** [March 18, 2020, 3:41pm UTC](https://discourse.julialang.org/t/problem-changing-variables-from-any-to-real/36116 "2020-03-18T15:41:18Z")

</div>

I tried running this using XLSX df = DataFrame(XLSX.readtable("C:/Users/brett/OneDrive/Documents/FemData.xlsx", "Sheet1")...) for name in names(df) df\[!, name\] = identity.(df\[:, name\]) end print(df) It changed…

---

## [Julia Database or CSV filtering](https://discourse.julialang.org/t/julia-database-or-csv-filtering/36104)

<div class="topic-metadata">

**Author:** [@bandaya](https://discourse.julialang.org/u/bandaya)\
**Replies:** 8\
**Last updated:** [March 18, 2020, 12:47pm UTC](https://discourse.julialang.org/t/julia-database-or-csv-filtering/36104 "2020-03-18T12:47:06Z")

</div>

Hi, I am using JuliaDB.jl package to upload CSV files but having problems with filtering or extracting some data. using JuliaDB # t = loadtable("MTab.csv") # Assume that the CSV contains the following data t = table(\[1,…

---

## [Filtering DataFrame on String](https://discourse.julialang.org/t/filtering-dataframe-on-string/36117)

<div class="topic-metadata">

**Author:** [@johnh](https://discourse.julialang.org/u/johnh)\
**Replies:** 2\
**Last updated:** [March 17, 2020, 10:56pm UTC](https://discourse.julialang.org/t/filtering-dataframe-on-string/36117 "2020-03-17T22:56:30Z")

</div>

Gahhhh… I show my ignorance. I have searched here and cannot quite get the answer. In the Kaggle covid-19 dataset I read covid\_19\_data.csv into a DataFrame The columns are: julia\> names(df) 8-element Array{Symbol,1}: …

---

## [2-dimensional DataFrame column](https://discourse.julialang.org/t/2-dimensional-dataframe-column/36060)

<div class="topic-metadata">

**Author:** [@martincornejo](https://discourse.julialang.org/u/martincornejo)\
**Replies:** 2\
**Last updated:** [March 17, 2020, 3:05pm UTC](https://discourse.julialang.org/t/2-dimensional-dataframe-column/36060 "2020-03-17T15:05:32Z")

</div>

MATLAB-tables and pandas-dataframe enable more than one element per cell (column-row pair). Is the same possible in Julia DataFrames? I tried for example: julia\> df = DataFrame(A = ones(10), B = ones(10,2)) which promp…

---

## [PL/Julia extension ( minimal )](https://discourse.julialang.org/t/pl-julia-extension-minimal/34232)

<div class="topic-metadata">

**Author:** [@ImreSamu](https://discourse.julialang.org/u/ImreSamu)\
**Replies:** 2\
**Last updated:** [March 15, 2020, 7:07am UTC](https://discourse.julialang.org/t/pl-julia-extension-minimal/34232 "2020-03-15T07:07:54Z")

</div>

" The following is only the beginning of an example to create a new procedural language for PostgreSQL. At some point later we will have something that enables user defined functions and stored procedures written in the J…

---

## [How to make compact subset queries of a dataframe?](https://discourse.julialang.org/t/how-to-make-compact-subset-queries-of-a-dataframe/35883)

<div class="topic-metadata">

**Author:** [@HenriDeh](https://discourse.julialang.org/u/HenriDeh)\
**Replies:** 5\
**Last updated:** [March 12, 2020, 5:10pm UTC](https://discourse.julialang.org/t/how-to-make-compact-subset-queries-of-a-dataframe/35883 "2020-03-12T17:10:04Z")

</div>

I am looking for a more elegant way to do this data\[(data.ID .== 1) .| (data.ID .== 4) .| (data.ID .== 7) .| (data.ID .== 10),: \] where data is a DataFrame. I simply want to extract rows where the ID value is one of th…

---

## [Dataframe identify rows](https://discourse.julialang.org/t/dataframe-identify-rows/35819)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 1\
**Last updated:** [March 11, 2020, 6:42am UTC](https://discourse.julialang.org/t/dataframe-identify-rows/35819 "2020-03-11T06:42:33Z")

</div>

I made a data frame from an xlsx spreadsheet, which has every month from Jan 1976- to Feb 2020 as columns, and as rows these variables. Month-year Population Labour force Employment Full-time employment Part-tim…

---

## [Loading COVID-19 CSV data](https://discourse.julialang.org/t/loading-covid-19-csv-data/35820)

<div class="topic-metadata">

**Author:** [@Glen](https://discourse.julialang.org/u/Glen)\
**Replies:** 2\
**Last updated:** [March 11, 2020, 4:17am UTC](https://discourse.julialang.org/t/loading-covid-19-csv-data/35820 "2020-03-11T04:17:16Z")

</div>

Hi Julians, I am trying to read the latest COVID-19 data to do analysis, from here: https://github.com/CSSEGISandData/COVID-19/blob/master/csse\_covid\_19\_data/csse\_covid\_19\_time\_series/time\_series\_19-covid-Confirmed.csv …

---

## [DataFrames not showing value](https://discourse.julialang.org/t/dataframes-not-showing-value/35743)

<div class="topic-metadata">

**Author:** [@brett\_knoss](https://discourse.julialang.org/u/brett_knoss)\
**Replies:** 11\
**Last updated:** [March 9, 2020, 9:25pm UTC](https://discourse.julialang.org/t/dataframes-not-showing-value/35743 "2020-03-09T21:25:49Z")

</div>

d = .05 n = .01 g = .015 s = .3 k = 6 i=s t=0:50 yn= function(t) ((y-k)+I\*t) using DataFrames df = DataFrame(A = yn, B = t) print(df) When I run this, istead of giving each value of yn for each value of t, it has #1…

---

## [Easiest quickest way to search DataFrame w/wildcards](https://discourse.julialang.org/t/easiest-quickest-way-to-search-dataframe-w-wildcards/35575)

<div class="topic-metadata">

**Author:** [@Usor](https://discourse.julialang.org/u/Usor)\
**Replies:** 7\
**Last updated:** [March 5, 2020, 3:21pm UTC](https://discourse.julialang.org/t/easiest-quickest-way-to-search-dataframe-w-wildcards/35575 "2020-03-05T15:21:54Z")

</div>

Is there an easy straightforward already existing way to search a DataFrame with a String wildcard in a specific column, and then print the found entries/rows? For example, you want to search if a certain name is in the…

---

## [Looking for a script that runs the same code with different set of parameters and saves the results in different folders](https://discourse.julialang.org/t/looking-for-a-script-that-runs-the-same-code-with-different-set-of-parameters-and-saves-the-results-in-different-folders/35437)

<div class="topic-metadata">

**Author:** [@Ujku\_KU](https://discourse.julialang.org/u/Ujku_KU)\
**Replies:** 7\
**Last updated:** [March 5, 2020, 1:38am UTC](https://discourse.julialang.org/t/looking-for-a-script-that-runs-the-same-code-with-different-set-of-parameters-and-saves-the-results-in-different-folders/35437 "2020-03-05T01:38:41Z")

</div>

Hi guys, I am running a set of experiments and each of experiment differs from the rest by the set of the parameters which are picked by the same pool of parameters. I would like to run the experiments in a loop automati…

[Previous page](https://discourse.julialang.org/c/domain/data/16.md?page=23)

[Next page](https://discourse.julialang.org/c/domain/data/16.md?page=25)