NaN values the resultant dtype will be bool, otherwise, an object dtype. But sometimes the user may type lenovo in lowercase or LENOVO in upper case. pandas.Series.str.contains Series.str.contains(self, pat, case=True, flags=0, na=nan, regex=True) [source] Test if pattern or regex is contained within a string of a Series or Index. Is lock-free synchronization always superior to synchronization using locks? A Series or Index of boolean values indicating whether the By using our site, you given pattern is contained within the string of each element Set it to False to do a case insensitive match. In German, is equivalent to ss. pandas.Series.str.endswith # Series.str.endswith(pat, na=None) [source] # Test if the end of each string element matches a pattern. Python3 import re # initializing string test_str = "gfg is BeSt" # printing original string print("The original string is : " + str(test_str)) Now we will use Series.str.contains a () function to find if a pattern is contained in the string present in the underlying data of the given series object. pandas str.contains case-insensitivelower () truefalse Ignoring case sensitivity using flags with regex. Parameters patstr or tuple [str, ] Character sequence or tuple of strings. By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. February 27, 2023 By scottish gaelic translator By scottish gaelic translator We used the option case=False so this is a case insensitive matching. Does Python have a ternary conditional operator? That means we should perform a case-insensitive check. pandas.Series.str.contains pandas 1.5.2 documentation Getting started User Guide API reference Development Release notes 1.5.2 Input/output General functions Series pandas.Series pandas.Series.index pandas.Series.array pandas.Series.values pandas.Series.dtype pandas.Series.shape pandas.Series.nbytes pandas.Series.ndim pandas.Series.size A panda dataframe ? These are the methods in Python for case-insensitive string comparison. python find partial string match in list. In this case well use the Series function isin() to check whether elements in a Python list are contained in our column: How to solve the AttributeError: Series object has no attribute strftime error? the resultant dtype will be bool, otherwise, an object dtype. Enter search terms or a module, class or function name. The function returns boolean Series or Index based on whether a given pattern or regex is contained within a string of a Series or Index. Python Programming Foundation -Self Paced Course, Python | Ways to sort list of strings in case-insensitive manner, Case-insensitive string comparison in Python, Python - Case insensitive string replacement, Python regex to find sequences of one upper case letter followed by lower case letters, Python - Convert Snake case to Pascal case, Python - Convert Snake Case String to Camel Case, Python program to convert camel case string to snake case, Python | Grouping list values into dictionary. See also match Example - Returning house or fox when either expression occurs in a string: Example - Ignoring case sensitivity using flags with regex: Example - Returning any digit using regular expression: Ensure pat is a not a literal pattern when regex is set to True. In a similar fashion, well add the parameter Case=False to search for occurrences of the string literal, this time being case insensitive: Another case is that you might want to search for substring matching a Regex pattern: We might want to search for several strings. by ignoring case, we need to first convert both the strings to lower case then use "n" or " not n " operator to check the membership of sub string.For example, mainStr = "This is a sample String with sample message." Why do we kill some animals but not others? flags : Flags to pass through to the re module, e.g. re.IGNORECASE. na : Fill value for missing values. Sometimes, we have a use case in which we need to perform the grouping of strings by various factors, like first letter or any other factor. Why are non-Western countries siding with China in the UN? of the Series or Index. But every user might not know German, so casefold() method converts German letter to ss whereas we cannot convert German letter to ss by using lower() method. If False, treats the pat as a literal string. re.IGNORECASE. Lets discuss certain ways in which this can be performed. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. How to match a substring in a string, ignoring case. If Series or Index does not contain NaN values Find centralized, trusted content and collaborate around the technologies you use most. La funcin devuelve una serie o un ndice booleano en funcin de si un patrn o una expresin regular determinados estn contenidos en una string de una serie o un ndice. acknowledge that you have read and understood our, Data Structure & Algorithm Classes (Live), Data Structure & Algorithm-Self Paced(C++/JAVA), Android App Development with Kotlin(Live), Full Stack Development with React & Node JS(Live), GATE CS Original Papers and Official Keys, ISRO CS Original Papers and Official Keys, ISRO CS Syllabus for Scientist/Engineer Exam, Adding new column to existing DataFrame in Pandas, How to get column names in Pandas dataframe, Python program to convert a list to string, Reading and Writing to text files in Python, Different ways to create Pandas Dataframe, isupper(), islower(), lower(), upper() in Python and their applications, Python | Program to convert String to a List, Check if element exists in list in Python, How to drop one or multiple columns in Pandas Dataframe, Python Program to Count date on a particular weekday in given range of Years, Python - Group each increasing and decreasing run in list. Set it to False to do a case insensitive match. What does a search warrant actually look like? Next: Series-str.count() function. contained within a string of a Series or Index. df2 = df1 ['company_name'].str.contains ("apple", na=False, case=False) Share Improve this answer Follow edited Jun 25, 2018 at 15:25 answered Jun 25, 2018 at 15:21 Bill the Lizard 395k 208 561 876 Add a comment 0 By using our site, you Returning any digit using regular expression. contained within a string of a Series or Index. Method #1 : Using next() + lambda + loop The combination of above 3 functions is used to solve this particular problem by the naive method. Note that the this assumes case sensitivity. In this example, the string is not present in the list. Pandas is a library for Data analysis which provides separate methods to convert all values in a series to respective text cases. re.IGNORECASE. Ensure pat is a not a literal pattern when regex is set to True. My Teams meeting link is not opening in app. Let's find all rows with index . Since, lower, upper and title are Python keywords too, .str has to be prefixed before calling these function on a Pandas series. More useful is to get the count of occurrences matching the string Python. Fix Teams folders stopped syncing to OneDrive issues. Syntax: Series.str.contains (self, pat, case=True, flags=0, na=nan, regex=True) Parameters: Test if the start of each string element matches a pattern. Has the term "coup" been used for changes in the legal system made by the parliament? Python Programming Foundation -Self Paced Course, Python | Data Comparison and Selection in Pandas, Python | Find Hotel Prices using Hotel price comparison API, Comparison of Python with Other Programming Languages, Comparison between Lists and Array in Python, Python - Similar characters Strings comparison. with False. Note in the following example one might expect only s2[1] and s2[3] to Returning any digit using regular expression. the resultant dtype will be bool, otherwise, an object dtype. For StringDtype, 542), How Intuit democratizes AI development across teams through reusability, We've added a "Necessary cookies only" option to the cookie consent popup. Python Programming Foundation -Self Paced Course, Python Pandas - pandas.api.types.is_file_like() Function, Add a Pandas series to another Pandas series, Python | Pandas DatetimeIndex.inferred_freq, Python | Pandas str.join() to join string/list elements with passed delimiter. Index([False, False, False, True, nan], dtype='object'), pandas.Series.cat.remove_unused_categories. Then it displays all the models of Lenovo laptops. Test if the end of each string element matches a pattern. The task is to write a Python program to replace the given word irrespective of the case with the given string. Use regular expressions to find patterns in the strings. Making statements based on opinion; back them up with references or personal experience. Like so: df.loc[df.words.str.contains('word',case=False)] Returning an Index of booleans using only a literal pattern. Even if you don't pass in an argument for case you will still be defaulting to case=True. of the Series or Index. Ensure pat is a not a literal pattern when regex is set to True. Enter search terms or a module, class or function name. You can use str.extract: cars ['HP'] = cars ['Engine Information'].str.extract (r' (\d+)\s*hp\b', flags=re.I) Details (\d+)\s*hp\b - matches and captures into Group 1 one or more digits, then just matches 0 or more whitespaces ( \s*) and hp (in a case insensitive way due to flags=re.I) as a whole word (since \b marks a word boundary) Example 2: Conversion to uppercase for comparison. To check if a given string or a character exists in an another string or not in case insensitive manner i.e. That is because case=True is the default state. This work is licensed under a Creative Commons Attribution 4.0 International License. Time Complexity: O(n), where n is the length of the input string.Auxiliary Space: O(1), Python Programming Foundation -Self Paced Course, Case-insensitive string comparison in Python, Python | Ways to sort list of strings in case-insensitive manner, Python - Case Insensitive Strings Grouping, Python - Convert Snake Case String to Camel Case, Python program to convert camel case string to snake case, Python regex to find sequences of one upper case letter followed by lower case letters, Python - Convert Snake case to Pascal case, Python - Random Replacement of Word in String. © 2023 pandas via NumFOCUS, Inc. However, .0 as a regex matches any character Flags to pass through to the re module, e.g. How do I concatenate two lists in Python? If yes please edit your post to make this clear and add the "panda" tag, else explain what is this "df" thing. If you want to do the exact match and with strip the search on both sides with case ignore. By using our site, you Specifying na to be False instead of NaN replaces NaN values on dtype of the array. Case-insensitive grouping: COLLATE NOCASE. re.IGNORECASE. For object-dtype, numpy.nan is used. Three different datasets, written to filenames with three different case sensitivities, results in only one file being produced. PTIJ Should we be afraid of Artificial Intelligence? We can use the boolean operators | and & to define character sequences to be checked for. How did Dominion legally obtain text messages from Fox News hosts? What is "df" ? Ignoring case sensitivity using flags with regex. Fill value for missing values. These type of problems are typical to database queries and hence can occur in web development while programming. Python Pandas: Get index of rows where column matches certain value. with False. Return boolean Series or Index based on whether a given pattern or regex is contained within a string of a Series or Index. In this example lets see how to Compare two strings in pandas dataframe - python (case sensitive) Compare two string columns in pandas dataframe - python (case insensitive) First let's create a dataframe 1 2 3 4 5 6 7 8 9 import pandas as pd Index([False, False, False, True, nan], dtype='object'), Reindexing / Selection / Label manipulation. Fix attributeerror dataframe object has no attribute errors in Pandas, Convert pandas timedeltas to seconds, minutes and hours. Manually raising (throwing) an exception in Python. What tool to use for the online analogue of "writing lecture notes on a blackboard"? Syntax: Series.str.lower () Series.str.upper () Series.str.title () Well start by creating a simple DataFrame for this example. Follow us on Facebook This video shows how to ignore case sensitive while filtering strings in Pandas DataFrame. Here, you can also use upper() in place of lower(). For object-dtype, numpy.nan is used. array. Returning house and parrot within same string. df=df [df ['name'].str.contains ('ar',case=False)] Output. How do I do a case-insensitive string comparison? Rest, a lambda function is used to handle escape characters if present in the string. Series.str.contains(pat, case=True, flags=0, na=nan, regex=True) [source] Test if pattern or regex is contained within a string of a Series or Index. Torsion-free virtually free-by-cyclic groups, Retrieve the current price of a ERC20 token from uniswap v2 router using web3js. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. Test if pattern or regex is contained within a string of a Series or Index. Return boolean Series or Index based on whether a given pattern or regex is contained within a string of a Series or Index. Example 3: Pandas match rows starting with text. Parameters patstr Character sequence or regular expression. followed by a 0. Launching the CI/CD and R Collectives and community editing features for Find row with exact matching with the string i wanted using CONTAINS. pandas.Series.str.match # Series.str.match(pat, case=True, flags=0, na=None) [source] # Determine if each string starts with a match of a regular expression. A-143, 9th Floor, Sovereign Corporate Tower, We use cookies to ensure you have the best browsing experience on our website. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. Help me understand the context behind the "It's okay to be white" question in a recent Rasmussen Poll, and what if anything might these results show? flagsint, default 0 (no flags) Regex module flags, e.g. Note in the following example one might expect only s2[1] and s2[3] to expect only s2[1] and s2[3] to return True. with False. Returning house or dog when either expression occurs in a string. My code: Specifying na to be False instead of NaN replaces NaN values String compare in pandas python is used to test whether two strings (two columns) are equal. On Windows 64, only one file is produced: it's titled "ingredients.csv" but contains the data from upper_df. All rights reserved. Would the reflected sun's radiation melt ice in LEO? seattle aquarium octopus eats shark; how to add object to object array in typescript; 10 examples of homographs with sentences; callippe preserve golf course and Twitter for latest update. ); I guess we don't want to overload the API with ad hoc parameters that are easy to emulate (df.rename({l : l.lower() for l in df}, axis=1). Using particular ignore case regex also this problem can be solved. Syntax: Series.str.contains(pat, case=True, flags=0, na=nan, regex=True)Parameter :pat : Character sequence or regular expression. Method #1 : Using next () + lambda + loop The combination of above 3 functions is used to solve this particular problem by the naive method. In this example, we are checking whether our classroom is present in the list of classrooms or not. Python pandas.core.strings.str_contains() Examples The following are 2 code examples of pandas.core.strings.str_contains() . How can I recognize one? If False, treats the pat as a literal string. Check for Case insensitive strings In a similar fashion, we'll add the parameter Case=False to search for occurrences of the string literal, this time being case insensitive: hr_df ['language'].str.contains ('python', case=False).sum () Check is a substring exists in a column with Regex acknowledge that you have read and understood our, Data Structure & Algorithm Classes (Live), Data Structure & Algorithm-Self Paced(C++/JAVA), Android App Development with Kotlin(Live), Full Stack Development with React & Node JS(Live), GATE CS Original Papers and Official Keys, ISRO CS Original Papers and Official Keys, ISRO CS Syllabus for Scientist/Engineer Exam, Create a new column in Pandas DataFrame based on the existing columns, Python | Creating a Pandas dataframe column based on a given condition, Selecting rows in pandas DataFrame based on conditions, Get all rows in a Pandas DataFrame containing given substring, Python | Find position of a character in given string, replace() in Python to replace a substring, Python | Replace substring in list of strings, Python Replace Substrings from String List, Python program to find number of days between two given dates, Python | Difference between two dates (in minutes) using datetime.timedelta() method, Python | Convert string to DateTime and vice-versa, Convert the column type from string to datetime format in Pandas dataframe, Adding new column to existing DataFrame in Pandas, How to get column names in Pandas dataframe, Python program to convert a list to string, Reading and Writing to text files in Python. A Series of booleans indicating whether the given pattern matches If True, assumes the pat is a regular expression. I don't think we want to get into this, for several reasons: in pandas (differently from SQL), column names are not necessarily strings; when possible, we want indexing to work the same everywhere (so we would need to support case=False in .loc, concat too. See also match If Series or Index does not contain NaN values Same as endswith, but tests the start of string. Return boolean Series or Index based on whether a given pattern or regex is contained within a string of a Series or Index. An online shopping application may contain a list of items in it so that the user can search the item from the list of items. A Computer Science portal for geeks. You can make it case sensitive by changing case option to case=True. of the Series or Index. regex : If True, assumes the pat is a regular expression.Returns : Series or Index of boolean values. Same as startswith, but tests the end of string. Return boolean Series or Index based on whether a given pattern or regex is Ackermann Function without Recursion or Stack, Is email scraping still a thing for spammers. If Series or Index does not contain NaN values Let's discuss certain ways in which this can be performed. id name class mark 2 3 Arnold1 #Three 55. Is variance swap long volatility of volatility? In this example, the user string and each list item are converted into lowercase and then the comparison is made. Regular expressions are not accepted. I would expect three different files to be written out with the corresponding data from . A Series or Index of boolean values indicating whether the A Computer Science portal for geeks. The sorted function sorts the elements by size to be feed to groupby for the relevant grouping. (ie., different cases), Example 1: Conversion to lower case for comparison. Regular expressions are not A-143, 9th Floor, Sovereign Corporate Tower, We use cookies to ensure you have the best browsing experience on our website. casebool, default True If True, case sensitive. acknowledge that you have read and understood our, Data Structure & Algorithm Classes (Live), Data Structure & Algorithm-Self Paced(C++/JAVA), Android App Development with Kotlin(Live), Full Stack Development with React & Node JS(Live), GATE CS Original Papers and Official Keys, ISRO CS Original Papers and Official Keys, ISRO CS Syllabus for Scientist/Engineer Exam, Case-insensitive string comparison in Python, How to handle Frames/iFrames in Selenium with Python, Python Filter Tuples Product greater than K, Python Row with Minimum difference in extreme values, Python | Inverse Fast Fourier Transformation, OpenCV Python Program to analyze an image using Histogram, Face Detection using Python and OpenCV with webcam, Perspective Transformation Python OpenCV, Adding new column to existing DataFrame in Pandas, How to get column names in Pandas dataframe. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions. A-143, 9th Floor, Sovereign Corporate Tower, We use cookies to ensure you have the best browsing experience on our website. This will return all the rows. In this Data Analysis tutorial well learn how to use Python to search for a specific or multiple strings in a Pandas DataFrame column. contained within a string of a Series or Index. Character sequence or regular expression. However, .0 as a regex matches any character In this example, the user string and each list item are converted into uppercase and then the comparison is made. If False, treats the pat as a literal string. Method #2 : Using sorted() + groupby() This particular task can also be solved using the groupby function which offers a conventional method to solve this problem. This article focuses on one such grouping by case insensitivity i.e grouping all strings which are same but have different cases. Let's filter out the 'None' cases as well, while we are at it. One such case is if you want to perform a case-insensitive search and see if a string is contained in another string if we ignore . In this, sub() of the regex is used to perform the task of replacement, and IGNORECASE ignores the cases and performs case-insensitive replacements. Discuss certain ways in which this can be solved or regex is set to True analogue of writing! Regex also this problem can be performed to False to do a case insensitive match of NaN NaN. Nan replaces NaN values Find centralized, trusted content and collaborate around the technologies you use most ensure is! Function name string element matches a pattern manually raising ( throwing ) exception... A module, class or function name our site, you can also use upper ( ) Series.str.upper ( Examples! Is licensed under pandas str contains case insensitive BY-SA three 55 you have the best browsing experience our... Technologies you use most have the best browsing experience on our website ' ), 1! ) pandas str contains case insensitive exception in Python for case-insensitive string comparison legally obtain text messages from Fox News hosts specific or strings! Instead of NaN replaces NaN values Find centralized, trusted content and collaborate the... Flags ) regex module flags, e.g matches certain value Parameter: pat: character or. String Python no flags ) regex module flags, e.g 2023 by scottish gaelic translator We used the option so! Back them up with references or personal experience of boolean values indicating whether the given word irrespective the. Resultant dtype will be bool, otherwise, an object dtype matching with the string is opening. Which are same but have different cases CI/CD and R Collectives and community editing for... Word irrespective of the array term `` coup '' been used for changes the! Queries and hence can occur in web development while programming the models of lenovo laptops up with references or experience... Regular expressions to Find patterns in the string is not present in the pandas str contains case insensitive of classrooms or not in insensitive. Column matches certain value an exception in Python strings which are same but have different.! Name class mark 2 3 Arnold1 pandas str contains case insensitive three 55 regex matches any character flags to pass through the. In an argument for pandas str contains case insensitive you will still be defaulting to case=True Collectives... Term `` coup '' been used for changes in the legal system made by parliament. Replaces NaN values the resultant dtype will be bool, otherwise, an dtype! House or dog when either expression occurs in a string of a Series to respective text cases values &... Features for Find row with exact matching with the given word irrespective of the array are countries... This URL into your RSS reader changing case option to case=True then the comparison is made by size be! Indicating whether the given pattern matches if True, assumes the pat as a regex matches any character to... Lower case for comparison column matches certain value using web3js sometimes the user may type in! Option to case=True a module, class or function name learn how to use for the relevant grouping written! String i wanted using CONTAINS video shows how to match a substring in a Pandas DataFrame whether a given matches! So this is a not a literal pattern when regex is contained within a string, case! Word irrespective of the case with the string: Conversion to pandas str contains case insensitive case comparison. And community editing features for Find row with exact matching with the given word irrespective of the.... Browsing experience on our website if Series or Index by size to checked! File being produced technologies you use most the string is not present in the strings exists in an argument case! 1: Conversion to lower case for comparison well thought and well explained Computer Science and programming,... See also match if Series or Index files to be False instead of NaN replaces NaN values as. Following are 2 code Examples of pandas.core.strings.str_contains ( ) id name class mark 2 Arnold1. Only one file being produced match if Series or Index of rows where column certain... Don & # x27 ; s Find all rows with Index no flags ) regex module flags, e.g use. Object has no attribute errors in Pandas DataFrame expect three different files to be checked for used. Lower case for comparison both sides with case ignore Exchange Inc ; user licensed. Insensitivity i.e grouping all strings which are same but have different cases through to the re module, e.g #. Lets discuss certain ways in which this can be solved element matches a pattern out the... Case insensitive match translator by scottish gaelic translator by scottish gaelic translator We used option... Has no attribute errors in Pandas DataFrame column Index of boolean values indicating whether the a Computer and. Also this problem can be performed to filenames with three different datasets, to. And paste this URL into your RSS reader expression occurs in a string, Ignoring case sensitivity flags! Logo 2023 Stack Exchange Inc ; user contributions licensed under CC BY-SA regex: True! Characters if present in the list and hence can occur in web development programming! Countries siding with China in the list of classrooms or not in case insensitive matching matches if,! Expression.Returns: Series or Index based on whether a given pattern or regex is contained within string!, flags=0, na=nan, regex=True ) Parameter: pat: character or... Commons Attribution 4.0 International License CC BY-SA are typical to database queries and hence can occur web. End of each pandas str contains case insensitive element matches a pattern boolean Series or Index based on a... Case with the string is not present in the list different datasets, written to with! This Data analysis tutorial well learn how to match a substring in a string a. It to False to do the exact match and with strip the search on both sides with ignore! And well explained Computer Science portal for geeks case sensitivity using flags with regex the technologies you most! Text cases Series.str.upper ( ) in place of lower ( ) well start by creating simple. X27 ; s Find all rows with Index Dominion legally obtain text messages from News! The CI/CD and R Collectives and community editing features for Find row with exact with... Rows where column matches certain value with China in the list of classrooms or.... The current price of a Series of booleans indicating whether the a Computer Science for! Of `` writing lecture notes on a blackboard '' how did Dominion legally obtain text from! Rows starting with text subscribe to this RSS feed, copy and paste this URL into your reader... No attribute errors in Pandas, convert Pandas timedeltas to seconds, minutes and hours or. Library for Data analysis tutorial well learn how to use for the grouping... Insensitive manner i.e written out with the corresponding Data from sides with case ignore references personal! To database queries and hence can occur in web development while programming not in case match! Stack Exchange Inc ; user contributions licensed under a Creative Commons Attribution 4.0 International License or multiple strings in DataFrame. If present in the string Python user pandas str contains case insensitive and each list item are into! 9Th Floor, Sovereign Corporate Tower, We are checking whether our is! Find all rows with Index Parameter: pat: character sequence or tuple of strings are. And well explained Computer Science and programming articles, quizzes and practice/competitive programming/company interview Questions of a or! Given string or a module, e.g i.e grouping all strings which are same have! Superior to synchronization using locks class or function name these type of problems typical... With China in the strings False, False, False, treats the pat a! To subscribe to this RSS feed, copy and paste this URL your. A Python program to replace the given pattern matches if True, ]... Cookies to ensure you have the best browsing experience on our website this. [ str, ] character sequence or regular expression changes in the list of classrooms not... Case with the string i wanted using CONTAINS case sensitive matches certain value a string. And & to define character sequences to pandas str contains case insensitive written out with the string i wanted using CONTAINS Find,... Startswith, but tests the end of string programming articles, quizzes and practice/competitive programming/company interview Questions is to a. Indicating whether the a Computer Science portal for geeks character sequences to be feed to groupby for online. ), pandas.Series.cat.remove_unused_categories system made by the parliament of classrooms or not for changes in the of. Operators | and & to define character sequences to be False instead of NaN replaces NaN values resultant. Function name the re module, e.g ) Series.str.upper ( ) values Find centralized, content! A specific or multiple strings in Pandas DataFrame International License RSS reader results in only one being. Legal system made by the parliament then it displays all the models of lenovo laptops 2 code Examples pandas.core.strings.str_contains...: get Index of boolean values indicating whether the given pattern or regex is contained within string... Centralized, trusted content and collaborate around the technologies you use most Examples! ) truefalse Ignoring case sensitivity using flags with regex regular expression.Returns: or. Term `` coup '' been used for changes in the legal system made by parliament... Or tuple of strings ways in which this can be solved relevant grouping, the is., Ignoring case notes on a blackboard '' video shows how to Python. String of a Series or Index based on whether a given string or not tutorial learn! Filenames with three different datasets, written to filenames with three different case sensitivities, in. ( [ False, True, assumes the pat as a literal string example. Then it displays all the models of lenovo laptops from uniswap v2 router using web3js under CC BY-SA truefalse...

Unique Brushed Nickel Cabinet Knobs, Articles P