splitrows col: column1 on: '\n' quote: '\"'
split col: column1 on: ',' limit: 14 quote: '\"'
header
drop col: Flag_Description
drop col: Unit
drop col: Flag
keep row: Note == '2010=100'
drop col: Note
drop col: Item_Code
drop col: Area_Code
drop col: Domain
drop col: Domain_Code
drop col: Months_Code
keep row: Item == '\"Consumer Prices, General Indices (2010 = 100)\"'
drop col: Year_Code
drop col: Item
derive value: max(Value) group: Area,Year as: 'max_Value'
derive value: min(Value) group: Year,Area as: 'min_Value'
keep row: (date(1970, 1, 1) <= Months) && (Months < date(1970, 2, 1))
drop col: Months
drop col: Value
derive value: count() group: Area as: 'countentries'
keep row: (17 <= countentries) && (countentries < 18)
drop col: countentries
keep row: in(Area, ['Brazil', 'Central African Republic', 'Germany', 'Mexico', 'Russian Federation', 'Saudi Arabia', 'Switzerland', 'United States of America'])
delete row: Area == 'Brazil'