Adding a new column to a dataframe

Thread Rating:

Thread Modes

Adding a new column to a dataframe

buran

Posts: 8,094

Threads: 154

Joined: Sep 2016

Reputation: 582

Jan-14-2021, 07:18 PM (This post was last modified: Jan-14-2021, 07:18 PM by buran.)

Also

data['DOW'] = data['date'].dt.strftime('%A')

data['DOW'] = data['date'].dt.day_name()

where date columns is already converted to datetime

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: Adding a new column to a dataframe - by buran - Jan-14-2021, 07:18 PM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	Adding PD DataFrame column	bsben	2	410	Mar-08-2024, 10:46 PM Last Post: deanhystad
	Python Alteryx QS-Passing pandas dataframe column inside SQL query where condition	sanky1990	0	825	Dec-04-2023, 09:48 PM Last Post: sanky1990
	Difference one column in a dataframe	Scott	0	707	Feb-10-2023, 08:41 AM Last Post: Scott
	splitting a Dataframe Column in two parts	nafshar	2	1,042	Jan-30-2023, 01:19 PM Last Post: nafshar
	How to assign a value to pandas dataframe column rows based on a condition	klllmmm	0	912	Sep-08-2022, 06:32 AM Last Post: klllmmm
	renaming the 0 column in a dataframe	Led_Zeppelin	5	1,738	Aug-16-2022, 04:07 PM Last Post: deanhystad
	Copy a column from one dataframe to another dataframe	Led_Zeppelin	17	12,148	Jul-08-2022, 08:40 PM Last Post: deanhystad
	Cannot convert the series to <class 'int'> when trying to create new dataframe column	Mark17	3	8,756	Jan-20-2022, 05:15 PM Last Post: deanhystad
	Filter dataframe by datetime.date column	glidecode	2	5,462	Dec-05-2021, 12:51 AM Last Post: glidecode
	Adding another condition for df column comparison	Mark17	2	1,746	Sep-30-2021, 03:54 PM Last Post: Mark17

Users browsing this thread: 1 Guest(s)