select columns based on columns names containing a specific string in pandas

by

alternative methods:

In [13]: df.loc[:, df.columns.str.startswith('alp')]
Out[13]:
       alp1      alp2
0  0.357564  0.108907
1  0.341087  0.198098
2  0.416215  0.644166
3  0.814056  0.121044
4  0.382681  0.110829
5  0.130343  0.219829
6  0.110049  0.681618
7  0.949599  0.089632
8  0.047945  0.855116
9  0.561441  0.291182

In [14]: df.loc[:, df.columns.str.contains('alp')]
Out[14]:
       alp1      alp2
0  0.357564  0.108907
1  0.341087  0.198098
2  0.416215  0.644166
3  0.814056  0.121044
4  0.382681  0.110829
5  0.130343  0.219829
6  0.110049  0.681618
7  0.949599  0.089632
8  0.047945  0.855116
9  0.561441  0.291182

More Related Contents:

  1. how many countries have organised more than one edition of olympic games? using python pandas [closed]
  2. How to sort a dataFrame in python pandas by two or more columns?
  3. Converting between datetime, Timestamp and datetime64
  4. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  5. Large, persistent DataFrame in pandas
  6. Pandas DENSE RANK
  7. Pandas “Can only compare identically-labeled DataFrame objects” error
  8. How to have clusters of stacked bars
  9. Pandas GroupBy and select rows with the minimum value in a specific column
  10. pandas concat generates nan values
  11. Constructing a co-occurrence matrix in python pandas
  12. Pandas Groupby and Sum Only One Column
  13. pandas xlsxwriter, format table header – not sheet header
  14. Pandas – Number of Months Between Two Dates
  15. Pandas Replace NaN with blank/empty string
  16. Modify the legend of pandas bar plot
  17. How do I convert a list in a Pandas DF into a string?
  18. How to append rows in a pandas dataframe in a for loop?
  19. pandas merging based on a timestamp which do not match exactly
  20. List of Tuples to DataFrame Conversion [duplicate]
  21. Pivot table subtotals in Pandas
  22. Pandas Latitude-Longitude to distance between successive rows [duplicate]
  23. Convert percent string to float in pandas read_csv
  24. Getting vertical gridlines to appear in line plot in matplotlib
  25. dataframe to long format
  26. How to iterate over columns of pandas dataframe to run regression
  27. Normalize DataFrame by group
  28. Python pandas – new column’s value if the item is in the list
  29. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  30. Pandas: Selecting rows based on value counts of a particular column

Leave a Comment