Hello, I have a Dataframe with a frequency matrix generate about events in relation to a user. [Captura de Pantalla 2020-09-16 a la(s) 12.48.07 a. m.] I need to reduce this matrix in unique USER_ID and sum each EVENT CATEGORY - events categories correspond to category 1,2,3,4. I have tried using…

If I understand you correctly you just want to groupby the USER_ID and then sum the columns? You can do this: julia> using DataFrames julia> df = hcat(DataFrame(USER_ID = rand(100:110, 20)), DataFrame(rand(0:1, 20, 10))) 20×11 DataFrame │ Row │ USER_ID │ x1 │ x2 │ x3 │ x4 │ x5 │ x6 …

Reduce and sum Value ( frequency matrix)

General Usage

xiaodai September 16, 2020, 6:17am 3

An MWE would help Please read: make it easier to help you

Is this what u mean?

using DataFrames
using DataConvenience: @> 

@> df begin
  groupby(:USER_ID)
  combine( 1:12 .=> sum)
end

1 Like

Topic		Replies	Views
Reduce DataFrame by unique value General Usage dataframes	5	1069	October 14, 2022
Efficiently finding the frequency of patterns in DataFrame columns New to Julia dataframes , dictionaries , splitapplycombine	12	1544	January 1, 2022
Creating a 3d frequency array for categorical variables from a dataframe New to Julia dataframes	3	674	February 12, 2021
Counting Occurrences in JuliaDB New to Julia juliadb	3	2016	March 11, 2019
Compute frequency or proportions on grouped dataframes Data dataframes	10	1155	June 14, 2021

Reduce and sum Value ( frequency matrix)

Related topics