Exact Match

[Kristenl2784]

Hello,

The first line of code is supposed to find string A180, and shift down 9 rows and grab that value. My problem is, is that I also have A180X inside this file, so It's not grabbing the correct information cause its also finding A180X.

The second Line I figured if I used ==String it would find the exact match and it does. My problem is, is when I add shift(9) I get an error 'str' object has no attribute 'shift'. Does anyone know how I can find the exact match but still use shift?

1 2 3

N2=NewFile2[NewFile2['FindString'].str.match(String,na=False).shift(9).fillna(False)]      N3=NewFile2[NewFile2['FindString']==(String).shift(9).fillna(False)]

[snippsat]

Should tell that you use Pandas not all is familiar with the syntax,and if give a working code example is easier to help.
In regex can use \b for a exact word match.
Bye working code i mean this.

1 2 3 4 5 6 7 8

import pandas as pd   d = {     'Quarters' : ['quarter1','quarter2','quarter3','quarter4'],      'Description': ['A180', ' A180X', ' A180123', 'A180'],      'Revenue': [23.5, 54.6, 5.45, 41.87] } df = pd.DataFrame(d)

Usage.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

>>> df['Description'].str.match(r'\bA180\b') 0     True 1    False 2    False 3     True Name: Description, dtype: bool >>> >>> df = df[df['Description'].str.match(r'\bA180\b')] >>> df    Quarters Description  Revenue 0  quarter1        A180    23.50 3  quarter4        A180    41.87 >>> >>> df.shift(-1)    Quarters Description  Revenue 0  quarter4        A180    41.87 3       NaN         NaN      NaN

[Kristenl2784]

Should tell that you use Pandas not all is familiar with the syntax,and if give a working code example is easier to help.
In regex can use \b for a exact word match.
Bye working code i mean this.

1 2 3 4 5 6 7 8

import pandas as pd   d = {     'Quarters' : ['quarter1','quarter2','quarter3','quarter4'],      'Description': ['A180', ' A180X', ' A180123', 'A180'],      'Revenue': [23.5, 54.6, 5.45, 41.87] } df = pd.DataFrame(d)

Usage.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

>>> df['Description'].str.match(r'\bA180\b') 0     True 1    False 2    False 3     True Name: Description, dtype: bool >>> >>> df = df[df['Description'].str.match(r'\bA180\b')] >>> df    Quarters Description  Revenue 0  quarter1        A180    23.50 3  quarter4        A180    41.87 >>> >>> df.shift(-1)    Quarters Description  Revenue 0  quarter4        A180    41.87 3       NaN         NaN      NaN

Hello,

using (r'\bA180\b') only works if you put the actual word between \b and \b, I wouldn't be able to use that because my string is constantly changing throughout the loop. That's why I have .str.match(String). It might be A180 for the first loop, and then second loop around it might me A180X, next A170.

---

Should tell that you use Pandas not all is familiar with the syntax,and if give a working code example is easier to help.
In regex can use \b for a exact word match.
Bye working code i mean this.

1 2 3 4 5 6 7 8

import pandas as pd   d = {     'Quarters' : ['quarter1','quarter2','quarter3','quarter4'],      'Description': ['A180', ' A180X', ' A180123', 'A180'],      'Revenue': [23.5, 54.6, 5.45, 41.87] } df = pd.DataFrame(d)

Usage.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

>>> df['Description'].str.match(r'\bA180\b') 0     True 1    False 2    False 3     True Name: Description, dtype: bool >>> >>> df = df[df['Description'].str.match(r'\bA180\b')] >>> df    Quarters Description  Revenue 0  quarter1        A180    23.50 3  quarter4        A180    41.87 >>> >>> df.shift(-1)    Quarters Description  Revenue 0  quarter4        A180    41.87 3       NaN         NaN      NaN

Hello,

using (r'\bA180\b') only works if you put the actual word between \b and \b, I wouldn't be able to use that because my string is constantly changing throughout the loop. That's why I have .str.match(String). It might be A180 for the first loop, and then second loop around it might me A180X, next A170. I have to many files to loop through to try and define each string individually.