I have scenario where I need to insert the missing data into dataframe dynamically. 3×3 DataFrame Row │ month ac_hrs crew_hrs │ String Int64 Int64 ─────┼────────────────────────── 1 │ 202404 2 4 2 │ 202405 4 6 3 │ 202406 5 7 julia>…

Another way forward (quite similar to pdeffebach suggestion): julia> df = DataFrame(month=["202404","202405","202406"], ac_hrs=[2,4,5], crew_hrs=[4,6,7]) 3×3 DataFrame Row │ month ac_hrs crew_hrs │ String Int64 Int64 ─────┼────────────────────────── 1 │ 202404 2 4 …

Identify and add missing rows dynamically in dataframe

General Usage

rocco_sprmnt21 April 9, 2024, 12:46pm 4


dfOP=permutedims(df,"month")
rm=1:parse(Int,names(dfOP)[2][end-1:end])-1
y=names(dfOP)[2][1:4]

insertcols!(dfOP,2,((y.*lpad.(rm,2,'0')).=>0)...)

Topic		Replies	Views
Insert dummy 0 value rows into dataframe General Usage dataframes	7	591	May 23, 2021
Fill gaps in DataFrame Data dataframes	10	1340	May 13, 2021
DataFrames. Cannot change missing values New to Julia	1	352	July 2, 2019
How to add a row to DataFrame where one field is missing New to Julia question , dataframes	4	966	September 17, 2020
Assignment of a `missing` value fails in DataFrames 0.11.1 Data	28	4856	June 28, 2018

Identify and add missing rows dynamically in dataframe

Related topics