Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

by
  1. df[x] — index a column using variable x. Returns pd.Series
  2. df[[x]] — index/slice a single-column DataFrame using variable x. Returns pd.DataFrame
  3. df['x'] — index a column named ‘x’. Returns pd.Series
  4. df[['x']] — index/slice a single-column DataFrame having only one column named ‘x’. Returns pd.DataFrame
  5. df.x — dot accessor notation, equivalent to df['x'] (there are, however, limitations on what x can be named if dot notation is to be successfully used). Returns pd.Series

With single brackets [...] you may only index a single column out as a Series. With double brackets, [[...]], you may select as many columns as you need, and these columns are returned as part of a new DataFrame.

Setup

df
   ID   x
0   0   0
1   1  15
2   2   0
3   3   0
4   4   0
5   5  15

x = 'ID'

Examples

df[x]

0    0
1    1
2    2
3    3
4    4
5    5
Name: ID, dtype: int64

type(df[x])
pandas.core.series.Series


df['x']

0     0
1    15
2     0
3     0
4     0
5    15
Name: x, dtype: int64

type(df['x'])
pandas.core.series.Series


df[[x]]

   ID
0   0
1   1
2   2
3   3
4   4
5   5

type(df[[x]])
pandas.core.frame.DataFrame


df[['x']]

    x
0   0
1  15
2   0
3   0
4   0
5  15

type(df[['x']])
pandas.core.frame.DataFrame


df.x

0     0
1    15
2     0
3     0
4     0
5    15
Name: x, dtype: int64

type(df.x)
pandas.core.series.Series

Further reading
Indexing and Selecting Data

More Related Contents:

  1. error when applying function to a series object
  2. How to convert index of a pandas dataframe into a column
  3. Pandas filtering for multiple substrings in series
  4. df.append() is not appending to the DataFrame
  5. Is there a simple way to change a column of yes/no to 1/0 in a Pandas dataframe?
  6. Combining two Series into a DataFrame in pandas
  7. Convert pandas Series to DataFrame
  8. Pandas selecting by label sometimes return Series, sometimes returns DataFrame
  9. how do I calculate a rolling idxmax
  10. Remove name, dtype from pandas output of dataframe or series
  11. Convert pandas data frame to series
  12. What is the fastest and most efficient way to append rows to a DataFrame?
  13. Compute the running (cumulative) maximum for a series in pandas
  14. Using replace efficiently in pandas
  15. Python Pandas iterate over rows and access column names
  16. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13
  17. How do I select rows from a DataFrame based on column values?
  18. Aggregation in Pandas
  19. Convert DataFrame column type from string to datetime
  20. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  21. Can pandas automatically read dates from a CSV file?
  22. pandas dataframe str.contains() AND operation
  23. Pandas groupby mean – into a dataframe?
  24. Drop columns whose name contains a specific string from pandas DataFrame
  25. Find the unique values in a column and then sort them
  26. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  27. From password-protected Excel file to pandas DataFrame
  28. How to filter a pandas dataframe based on the length of a entry
  29. How can repetitive rows of data be collected in a single row in pandas?
  30. How is pandas groupby method actually working?

Leave a Comment