Julia language: DataFrames: insert a column

 The following code 

1. inserts a new column into DataFrame named df
2. inserts this column as a first (col_ind =1) column
3. names this column Rata_Die
4. populates the column values with an array of Int64 zeros (0)
5. makes sure the name of the column is unique

col_ind = 1

insertcols!(df, col_ind, :Rata_Die => zeros(Int64, record_count); makeunique = true )

Julia language: DataFrames: insert a column

 The following code 

1. inserts a new column into DataFrame named df
2. inserts this column as a first (col_ind =1) column
3. names this column Rata_Die
4. populates the column values with an array of Int64 zeros (0)
5. makes sure the name of the column is unique

col_ind = 1

insertcols!(df, col_ind, :Rata_Die => zeros(Int64, record_count); makeunique = true )

Julia DataFrames

 

Filtering DataFrame

New Syntax

 

Syntax explained:

1. from original "data" (type DataFrames)
2. create new "dataA" (type DataFrames)
3. filter indices in column "Treatment" with values equal to "A"
4. include ALL COLUMNS indicated by ":"
5. Show the first 6 rows

dataA = data[isequal.(data.Treatment, "A"), : ] 

first(dataA, 6)

6 rows × 5 columns

	Age	WCC	CRP	Treatment	Result
	Int64	Float64	Int64	String	String
1	37	10.2	30	A	Worse
2	67	10.4	70	A	Worse
3	42	10.4	100	A	Static
4	56	12.5	80	A	Worse
5	60	9.5	0	A	Static
6	62	13.7	10	A	Worse

 

Deprecated Syntax

# dataA = data[data[:Treatment] .== "A", :] 

 

Warning: `getindex(df::DataFrame, col_ind::ColumnIndex)` is deprecated, use `df[!, col_ind]` instead.

Julia DataFrames

 

Filtering DataFrame

New Syntax

 

Syntax explained:

1. from original "data" (type DataFrames)
2. create new "dataA" (type DataFrames)
3. filter indices in column "Treatment" with values equal to "A"
4. include ALL COLUMNS indicated by ":"
5. Show the first 6 rows

dataA = data[isequal.(data.Treatment, "A"), : ] 

first(dataA, 6)

6 rows × 5 columns

	Age	WCC	CRP	Treatment	Result
	Int64	Float64	Int64	String	String
1	37	10.2	30	A	Worse
2	67	10.4	70	A	Worse
3	42	10.4	100	A	Static
4	56	12.5	80	A	Worse
5	60	9.5	0	A	Static
6	62	13.7	10	A	Worse

 

Deprecated Syntax

# dataA = data[data[:Treatment] .== "A", :] 

 

Warning: `getindex(df::DataFrame, col_ind::ColumnIndex)` is deprecated, use `df[!, col_ind]` instead.