Questions tagged [julia-dataframe]
51 questions
0
votes
1 answer
Julia datetime, format without seconds
How do I remove the seconds from showing up in the plot below? (The date format change seems to not alter the plot at all!)
using DataFrames, Dates, Plots
gr(linewidth=3, markersize=4, titlefont=18, legendfont=12, guidefont=18, tickfont=14,…
hegdep
- 596
- 1
- 6
- 16
0
votes
1 answer
ArgumentError: no default `Tables.columns` implementation for type: XLSX.XLSXFile
I have a very simple excel file (.xlsx) it contains just 2 columns and 2 rows with values.
But when I run the code below I get ArgumentError: no default `Tables.columns` implementation for type: XLSX.XLSXFile, for both readxlsx and openxlsx Why is…
hbrovell
- 547
- 6
- 17
0
votes
2 answers
Add thousands separator to column in dataframe in julia
I have a dataframe with two columns a and b and at the moment both are looking like column a, but I want to add separators so that column b looks like below. I have tried using the package format.jl. But I haven't gotten the result I'm afte. Maybe…
hbrovell
- 547
- 6
- 17
0
votes
2 answers
Simple Table Operation Has Very Large Compilation Time with MLJ
I am trying to use MLJ on a DataFrame (30,000 rows x 8,000 columns) but every table operation seems to take a huge amount of time to compile but is fast to run.
I have given an example with code below in which a 5 x 5000 DataFrame is generated and…
Jack N
- 324
- 2
- 14
0
votes
1 answer
Counting occurrences and making calculations with a dataframe
I have column in a dataframe like this:
df = DataFrame(:num=>rand(0:10,20))
From df I want to make 2 others dataframe:
df1 = counter(df[!,:num)
To have the frequencies of each integer from 0 to 10. But I need the values sorted from 0 to…
pouchewar
- 399
- 1
- 10
0
votes
1 answer
I can't print the column value or row value of Dataframes in julia. I am getting a not found error?
I searched a lot. I am reading the document. but still could not figure it out. Whichever way I try it says no column name and gives an error. Thank you in advance for your help
print(daf[!,:SPV])
Output:
ERROR: LoadError: ArgumentError: column…
sabcan
- 407
- 3
- 15