Substring and If then Condition to create column

Thread Rating:

Thread Modes

Substring and If then Condition to create column

buran

Posts: 8,089

Threads: 154

Joined: Sep 2016

Reputation: 582

Jan-23-2020, 08:40 AM

just to add that you can also use

 if i.lower().startswith(("h", "m")):

PEP8 recommends using str.startswith() and str.endswith() methods instead of slicing

If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Messages In This Thread

RE: Substring and If then Condition to create column - by buran - Jan-23-2020, 08:40 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Get an average of the unique values of a column with group by condition and assign it	klllmmm	0	577	Feb-17-2024, 05:53 PM Last Post: klllmmm
	Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition	sanky1990	0	865	Dec-04-2023, 09:48 PM Last Post: sanky1990
	extract substring from a string before a word !!	evilcode1	3	711	Nov-08-2023, 12:18 AM Last Post: evilcode1
	[SOLVED] [regex] Why isn't possible substring ignored?	Winfried	4	1,252	Apr-08-2023, 06:36 PM Last Post: Winfried
	create new column based on condition	arvin	12	2,626	Dec-13-2022, 04:53 PM Last Post: jefsummers
	How to assign a value to pandas dataframe column rows based on a condition	klllmmm	0	982	Sep-08-2022, 06:32 AM Last Post: klllmmm
	ValueError: substring not found	nby2001	4	8,304	Aug-08-2022, 11:16 AM Last Post: rob101
	Match substring using regex	Pavel_47	6	1,597	Jul-18-2022, 07:46 AM Last Post: Pavel_47
	Python create a spreadsheet with column and row header	ouruslife	4	1,895	Jul-09-2022, 11:01 AM Last Post: Pedroski55
	Cannot convert the series to <class 'int'> when trying to create new dataframe column	Mark17	3	8,875	Jan-20-2022, 05:15 PM Last Post: deanhystad

Users browsing this thread: 1 Guest(s)