Syntax Error When Creating A Dataframe

Question

I have a Dataframe with a Country column as well as year columns (spanning from 1960 - 2015). I wish to create a new Dataframe only containing the Country and the columns within the last ten years.

I have managed to get the last ten years into a Dataframe but not the Countries they correspond to.

df = df[['Country', '%d' % i for i in range(2006, 2016)]]

From the code above, I get returned a syntax error. What am I doing wrong?

akuiper · Accepted Answer · 2016-12-28 14:23:09Z

2

The for syntax in python needs to be wrapped either in parenthesis (creating a generator) or in brackets (creating a list). You need a list of columns in this case. So wrap the for loop in a pair of bracket to make it a list of columns and then concatenate it with Country with +:

df = df[['Country'] + ['%d' % i for i in range(2006, 2016)]]

Or as @DeepSpace commented, use str method to convert integer to string:

df = df[['Country'] + [str(i) for i in range(2006, 2016)]]

edited Dec 28, 2016 at 14:23

answered Dec 28, 2016 at 14:21

akuiper

216k33 gold badges362 silver badges379 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

DeepSpace Over a year ago

Yeah, but '%d' % i feels really unnecessary here. str(i) will be enough.

user7350180 Over a year ago

Thanks for the help and suggestion.

Collectives™ on Stack Overflow

Syntax Error When Creating A Dataframe

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related