Print the raw value of a column alone, in pandas?

by

You can use loc + values for converting Serie to numpy array and then select first value by [0]:

print (df.loc[df.name == 'george', 'age'].values)
[23]
print (df.loc[df.name == 'george', 'age'].values[0])
23

Or simply select first value of Series with iloc:

print (df.loc[df.name == 'george', 'age'].iloc[0])
23

Or select first item by iat:

print (df.loc[df.name == 'george', 'age'].iat[0])
23

Or use Series.item:

print (df.loc[df.name == 'george', 'age'].item())
23

If possible no match value, above solutions failed.

Then is possible use next with iter trick:

print (next(iter(df.loc[df.name == 'george', 'age']),'no match value'))
23

print (next(iter(df.loc[df.name == 'jano z hornej dolnej', 'age']),'no match value'))
no match value

More Related Contents:

  1. Select nan column in pandas
  2. How to identify and label similar rows in a pandas data frame
  3. Renaming column names in Pandas
  4. How can I use the apply() function for a single column?
  5. Filtering Pandas DataFrames on dates
  6. Remove duplicates by columns A, keeping the row with the highest value in column B
  7. How can I display full (non-truncated) dataframe information in HTML when converting from Pandas dataframe to HTML?
  8. Pandas create new column with count from groupby
  9. How to qcut with non unique bin edges?
  10. Pandas select rows and columns based on boolean condition
  11. Access to table objects on Webpage Using Python Selenium
  12. Most efficient way to sort an array into bins specified by an index array?
  13. creating multiple excel worksheets using data in a pandas dataframe
  14. Python Pandas Conditional Sum with Groupby
  15. Get all combinations of elements from two lists?
  16. Impute categorical missing values in scikit-learn
  17. Can You Consistently Keep Track of Column Labels Using Sklearn’s Transformer API?
  18. Using conditional to generate new column in pandas dataframe
  19. AttributeError: ‘DataFrame’ object has no attribute ‘ix’
  20. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x96 in position 35: invalid start byte
  21. Writing large Pandas Dataframes to CSV file in chunks
  22. NumPy version of “Exponential weighted moving average”, equivalent to pandas.ewm().mean()
  23. Split pandas dataframe based on values in a column using groupby
  24. How to merge a Series and DataFrame
  25. FutureWarning: The default value of regex will change from True to False in a future version
  26. Python making combined bar and line plot with secondary y-axis
  27. pandas convert from datetime to integer timestamp
  28. geopandas point in polygon
  29. Rename columns in Pandas based on a dictionary
  30. When is it appropriate to use df.value_counts() vs df.groupby(‘…’).count()?

Leave a Comment