How to get column by number in Pandas?

by

One is a column (aka Series), while the other is a DataFrame:

In [1]: df = pd.DataFrame([[1,2], [3,4]], columns=['a', 'b'])

In [2]: df
Out[2]:
   a  b
0  1  2
1  3  4

The column ‘b’ (aka Series):

In [3]: df['b']
Out[3]:
0    2
1    4
Name: b, dtype: int64

The subdataframe with columns (position) in [1]:

In [4]: df[[1]]
Out[4]:
   b
0  2
1  4

Note: it’s preferable (and less ambiguous) to specify whether you’re talking about the column name e.g. [‘b’] or the integer location, since sometimes you can have columns named as integers:

In [5]: df.iloc[:, [1]]
Out[5]:
   b
0  2
1  4

In [6]: df.loc[:, ['b']]
Out[6]:
   b
0  2
1  4

In [7]: df.loc[:, 'b']
Out[7]:
0    2
1    4
Name: b, dtype: int64

More Related Contents:

  1. Clustered Stacked Bar in Python Pandas [closed]
  2. Python Pandas – Find difference between two data frames
  3. Convert pandas timezone-aware DateTimeIndex to naive timestamp, but in certain timezone
  4. Rename Pandas DataFrame Index
  5. Pandas groupby cumulative sum
  6. Pandas DataFrame concat vs append
  7. Convert row to column header for Pandas DataFrame,
  8. Use AWS Glue Python with NumPy and Pandas Python Packages
  9. What is the most efficient way of counting occurrences in pandas?
  10. Pandas read csv file with float values results in weird rounding and decimal digits
  11. pandas – filter dataframe by another dataframe by row elements
  12. How to set some xlim and ylim in Seaborn lmplot facetgrid
  13. Left justify string values in a pandas DataFrame
  14. Python Pandas: How to read only first n rows of CSV files in?
  15. Pandas – replacing column values
  16. Override global variable inside function not working with Spyder 4
  17. Pandas: Datetime Improperly selecting day as month from date [duplicate]
  18. join or merge with overwrite in pandas
  19. Pandas get the age from a date (example: date of birth)
  20. How to create a grouped bar plot
  21. Sample each group after pandas groupby
  22. Python Pandas – Missing required dependencies [‘numpy’] 1
  23. Pandas Data Frame how to merge columns
  24. Bar graph from dataframe groupby
  25. What are the differences between feather and parquet?
  26. Reading multiple JSON records into a Pandas dataframe
  27. Grouped Bar graph Pandas
  28. pandas group by and assign a group id then ungroup
  29. Pandas: Join dataframe with condition
  30. Creating multiple Excel worksheets using data from a pandas DataFrame

Leave a Comment