extract column value based on another column pandas dataframe

by

You could use loc to get series which satisfying your condition and then iloc to get first element:

In [2]: df
Out[2]:
    A  B
0  p1  1
1  p1  2
2  p3  3
3  p2  4

In [3]: df.loc[df['B'] == 3, 'A']
Out[3]:
2    p3
Name: A, dtype: object

In [4]: df.loc[df['B'] == 3, 'A'].iloc[0]
Out[4]: 'p3'

More Related Contents:

  1. how to calculation cost time [closed]
  2. How to add a new column to an existing DataFrame?
  3. String concatenation of two pandas columns
  4. pandas: filter rows of DataFrame with operator chaining
  5. Reshape wide to long in pandas
  6. How do I create test and train samples from one dataframe with pandas?
  7. Pandas – Slice large dataframe into chunks
  8. What is the difference between using loc and using just square brackets to filter for columns in Pandas/Python?
  9. python – Using pandas structures with large csv(iterate and chunksize)
  10. Group duplicate column IDs in pandas dataframe
  11. How to convert column with list of values into rows in Pandas DataFrame
  12. Remove or replace spaces in column names
  13. Python – splitting dataframe into multiple dataframes based on column values and naming them with those values [duplicate]
  14. Shift NaNs to the end of their respective rows
  15. how to read certain columns from Excel using Pandas – Python
  16. OSError: Initializing from file failed on csv in Pandas
  17. Convert column to row in Python Pandas
  18. Putting many python pandas dataframes to one excel worksheet
  19. Remove Unnamed columns in pandas dataframe [duplicate]
  20. How to slice a pandas DataFrame by position?
  21. Filling in date gaps in MultiIndex Pandas Dataframe
  22. Writing a Python Pandas DataFrame to Word document
  23. Find unique values in a Pandas dataframe, irrespective of row or column location
  24. Efficient way to add rows to dataframe
  25. Find names of top-n highest-value columns in each pandas dataframe row
  26. Convert pandas DataFrame into list of lists [duplicate]
  27. Got continuous is not supported error in RandomForestRegressor
  28. Copy text between parentheses in pandas DataFrame column into another column
  29. Get frequency of item occurrences in a column as percentage [duplicate]
  30. Get max value from row of a dataframe in python [duplicate]

Leave a Comment