Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- splitrows col: column1 on: '\r\n'
- split col: column1 on: ',' limit: 92 quote: '\"'
- header
- drop col: Country_Code
- drop col: Item_Code
- drop col: Element_Code
- drop col: Y1971F
- drop col: Y1970F
- drop col: Y1972F
- drop col: Y1973F
- drop col: Y1974F
- drop col: Y1975F
- drop col: Y2010F
- drop col: Y2009F
- drop col: Y2008F
- drop col: Y2011F
- drop col: Y2012F
- drop col: Y2007F
- drop col: Y2006F
- drop col: Y2005F
- drop col: Y2004F
- drop col: Y2003F
- drop col: Y2002F
- drop col: Y2001F
- drop col: Y2000F
- drop col: Y1999F
- drop col: Y1998F
- drop col: Y1997F
- drop col: Y1996F
- drop col: Y1995F
- drop col: Y1994F
- drop col: Y1993F
- drop col: Y1992F
- drop col: Y1991F
- drop col: Y1990F
- drop col: Y1989F
- drop col: Y1988F
- drop col: Y1987F
- drop col: Y1986F
- drop col: Y1985F
- drop col: Y1984F
- drop col: Y1983F
- drop col: Y1982F
- drop col: Y1981F
- drop col: Y1980F
- drop col: Y1979F
- drop col: Y1978F
- drop col: Y1977F
- drop col: Y1976F
- delete row: !in(Element, ['Emissions (CO2) (Energy)'])
- delete row: !in(Item, ['Total Energy'])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement