Filter by Repetitions

 

Example

Part of the data in Excel file Book1.xlsx is as follows:

June

April

March

August

December

September

February

September

December

December

The task is to find the months that appear less than 4 times, and the results are as follows:

April

January

May

November

October

September

Write SPL script:


A

1

=file("Book1.xlsx").xlsimport()

2

=A1.group(#1).select(~.len()<4).(~(1))

3

=file("result.xlsx").xlsexport(A2)

A1 Read the excel file

A2 Group the data, filter out the results with less than 4 in the group and take one value in each group

A3 Export results to result.xlsx