JuliaDB is a Julia-lang package for working with persistent data sets.
JuliaDB is a Julia-lang package for working with persistent data sets. https://juliadb.org/
Questions tagged [juliadb]
13 questions
9
votes
1 answer
Get column names from DataFrame or JuliaDB table
How do I get the column names from a DataFrame object or JuliaDB IndexedTable object? Is this possible?
Reproducible Code:
using JuliaDB
import DataFrames
DF = DataFrames
# CREATES AN EXAMPLE TABLE WITH JULIADB
colnames = [:samples, :A, :B, :C,…
bug_spray
- 1,445
- 1
- 9
- 23
3
votes
1 answer
Reading dates with JuliaDB
I am very new to Julia, and I am having an issue with JuliaDB loadtable("myfile").If I understand well, the problem is that the dates are in the format dd/mm/yyyy, e.g. 21/07/1985. I am told 'ArgumentError:Month: 14 out of range (1:12). How can I…
Joao
- 31
- 1
3
votes
1 answer
What is missing in JuliaDB to use it as production database in a website backend?
I have some difficulties to understand the pros and the cons of using JuliaDB as a main backend database for a production website.
https://juliadb.org/
My use case is a collaborative data sciences platform. The client request 1 million unique…
Morgane
- 155
- 8
2
votes
1 answer
Is there any Percentage change method in JuliaDB
Is there any JuliaDB method that calculates the percentage change between timestamps.If not a JuliaDB lag method will be usefull.
Bouarfa Mahi
- 59
- 1
- 4
2
votes
1 answer
How to Edit a Row in JuliaDB?
Is there a way to edit a field in JuliaDB? I want to modify column y where column x == 4.
using JuliaDB
t = table((x = [1,4,5,6], y = [2,2,24,5]))
I found a thing somewhere showing how to do this.. but it didn't work any more.. it used merge or…
Matt Camp
- 1,448
- 3
- 17
- 38
1
vote
1 answer
How do I get datetime from JuliaDB NDSparse?
I need to compute the time derivative of a data column
dateformat yyyy-mm-dd HH:MM:SS.sss
1-d NDSparse with 40508 values (6 field named tuples):
Date
2019-03-01T02:46:44.658
2019-03-01T02:46:44.811
2019-03-01T02:46:45.119
2019-03-01T02:46:45.222…
Bouarfa Mahi
- 59
- 1
- 4
1
vote
0 answers
JuliaDB groupby many columns in one time
I’m trying to groupby using JuliaDB , everything works well except when i want to apply a function that takes two columns in one time.
JuliaDB.groupby(
(
TOTAL_PAID = :PRICE => sum,
FREQUENCY_IN_DAYS = :ORDER_DATE =>…
echo55
- 329
- 1
- 9
1
vote
1 answer
Get JuliaDB.loadtable() to parse all columns as String
I want JuliaDB.loadtable() to read a CSV (really a bunch of CSVs, but for simplicity let's try just one), where all columns are parsed as String.
Here's what I've tried:
using CSV
using DataFrames
using JuliaDB
df1 = DataFrame(
[['a', 'b',…
ardaar
- 1,164
- 9
- 19
1
vote
1 answer
Is it possible to unpack a dictionary of parameters in a JuliaDB push!() function?
I recognize that JuliaDB may still be a bit rough around the edges, but I was wondering if it's possible to do something like this:
push!(rows(mse_table), table_params...) # add row
Instead of something like this:
push!(rows(mse_table),…
bug_spray
- 1,445
- 1
- 9
- 23
1
vote
1 answer
Why Julia/JuliaDB behaves differently while filtering?
Executing
filter(i -> !ismissing(i.dep_delay > 60), select(flights, (:carrier, :dep_delay)))
should return the carriers with delay more than 60mins(my understanding!). But it returns carriers with all positive and negative dep_delays.
Why it…
AVA
- 2,474
- 2
- 26
- 41
1
vote
1 answer
How to use summarise function in JuliaDB?
I am following the tutorial published at https://github.com/JuliaComputing/JuliaDB.jl/blob/master/docs/src/tutorial.md
a) While executing:
summarize(mean ∘ skipmissing, flights, :Dest, select = (:Cancelled, :Diverted))
getting:
Error:…
AVA
- 2,474
- 2
- 26
- 41
0
votes
1 answer
JuliaDB select a column from a string, not a symbol
I want to select a column from a JuliDB database. The problem is that I can't do it with string (not a symbol that starts with :), for example:
db = loadtable("table.dat")
#This table has 3 columns named position_1, position2, position_3
pos_num =…
oscarcapote
- 417
- 1
- 4
- 16
0
votes
2 answers
JuliaDB groupby: mixing sum with constants
I want to sum the elements of a table grouped by a field and then divided by a constant: For example, I have a table with department and sells and I want to sum all the sells of each department and then divide by 100 (for example). That's the…
oscarcapote
- 417
- 1
- 4
- 16