Selecting rows of a dataframe based on value/string pattern in a column

Comparing a string pattern with values in a column of a pandas DataFrame.

Many times i have seen that,

x_df.loc[x_df.column_A == "xyz",:] fails to return the rows which contain "xyz" in the column_A of Data Frame x_df

Its always better to use below code for this task of selecting rows where column_A has "xyz" as its value,

x_df[x_df['column_A'].str.contains("xyz")]

Comments

Post a Comment

Popular posts from this blog

 I found a very strange anamoly of a code working on Jupyter notebook, but its not working on the app.python from a flask applicatoin. When the type of column names if int instead of string, the str.replace() code works on the jupyter notebook, but does not work in the flask python. Scenario: I have a dataframe having year-months(For example 202001, 202002 etc.) as the column name. Now I want to have a replace code, like, col = [ '201911', '201912','202001', '202002', '202003', '202004', '202005', '202006', '202007', '202008','202009','202010']  the below code works on the jupyter notebook, but fails on the flask. data_df[col] = data_df[col].replace(to_replace=['-',' ','\*'], value='', regex=True).astype(float)
Read more
Some Html Issues faced while working with Angular 2. Checkbox not getting selected on Screen. --------------------------------------------------          Soultion: Changed the z-index of checkbox and moved it to the front. Only one checkbox getting selected. --------------------------------------------------         Solution: Added a handler on the click, sent the event to the handler, and called event.stopPropagation() inside handler.
Read more
Feature of Scrolling in a page in RMarkdown Flexdashboard. ---------------------------------------------------------------------------------- I was using Flexdashboard with RMarkdown and faced an issue. When I was adding more rows, it used to squeeze the existing plots on the page and i was not getting the feature of scrolling automatically. I saw all the examples of Flexdashboard from the author, but every example had only 3-4 plots which fit in a single page. I search for some documentation but could not find one. Solution: We have to include a small key-value pair text, " vertical_layout: scroll" and it worked like magic and i had very nice scrolling feature on my page.
Read more