Defining a column in an excel file using pandas

Viewed 71

How do I select a column in an excel file and display it only by pandas I tried:

    videos = df.loc[:, df.columns == 'videos']
    videosvar = (videos.loc[num].values)
    print(videosvar)
2 Answers

You can select column by directly mentioning the column name.

videos_column = videosvar["videos"]  # returns the column as a series

If need select by indice and column name use:

videosvar = df.loc[num, 'videos']
Related