Python filter data

Question

I am having trouble understanding the last line of this code. The csv file has several columns, but after the last line, only the data below the columns specified remains. What confuses me is why we use 4 brackets instead of two.

import pandas

data = pandas.read_csv("student-mat.csv", sep=";")

data = data[["G1", "G2", "G3", "studytime", "failures", "absences"]]

This is Pandas syntax to select multiple columns. See more [here](https://stackoverflow.com/questions/11285613/selecting-multiple-columns-in-a-pandas-dataframe) — Tom Ron, Jul 07 '19 at 07:36

score 0 · Answer 1 · answered Jul 07 '19 at 07:39

0

The single bracket will output a Pandas Series, while a double bracket will output a Pandas DataFrame.

answered Jul 07 '19 at 07:39

bart

1,003
11
24

score 0 · Answer 2 · answered Jul 07 '19 at 07:43

0

The interior brackets are for list whereas the outer brackets are for indexing operator. Double brackets are needed if you select two or more columns.

answered Jul 07 '19 at 07:43

Mohamed Yilmaz

66
5

Python filter data

2 Answers2