python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - week-number

To get the week number in a column using Python

I was trying to get this requirement where I want to have a column in my dataframe with week number, based on Days, Month an yr present in data. Here is the below code- import pandas as pd import nump...
test-img

John

python

date

datetime

week-number

Votes: 0

Answers: 1

Latest Answer

This line isn't as nice, but it works: p['week'] = [datetime.datetime.strptime(str(p['yr'][i])+p['Month'][i]+str(p['Days'][i]), '%Y%b%d').isocalendar()[1] for i in range(len(p))]
test-img

Ukulele

How to construct date from (year, weekOfYear, dayOfWeek) in Snowflake?

I have a situation where using Snowflake, I need to construct a date from these parts (year, weekOfYear, dayOfWeek). ie (2022, 13th week, 3 for Weds) would equate to today's date 2022-03-30. While th...
test-img

EricB

sql

date

snowflake-cloud-data-platform

dayofweek

week-number

Votes: 0

Answers: 2

Latest Answer

Remember to set following parameter to ensure that, the first week of the year is the week that contains January 1st of that year. ALTER SESSION SET WEEK_OF_YEAR_POLICY = 1; +-------------------------...
test-img

Pankaj

Python: Find date of monday of a given calender week in a given year

I have a questions about Python. My goal is the following: Let a year and a calender week be given. Then I want to find the calender date of the Monday of this calender week. I want to use the calende...
test-img

Stephaela

python

calendar

week-number

Votes: 0

Answers: 1

Latest Answer

At the moment, your function works for most inputs. Of course, if you are handling week 53+, then do you want to handle non-positive inputs? If you give a zero/negative week-number then the function g...
test-img

Ukulele

Excel how to convert weeknum to date when crossing the year

I have a table with Date column and weeknum column. The weeknum column has below formula to create a srting: 2022/10. =YEAR([@[Date]})&"/"&WEEKNUM([@[Date]],2) I would like to get t...
test-img

P002143_k

excel

excel-formula

dayofweek

week-number

Votes: 0

Answers: 1

Latest Answer

You can do this by taking the weekday number of the date away from itself and adding 7-weekday to itself. i.e. If we use the first date on your list and we say weeks start on Monday: The first day of ...
test-img

NelliNoodle

Posts

Questions

Blogs

Jobs