擅长:python、mysql、java
<p>看看这个<a href="https://stackoverflow.com/questions/7029261/python-number-of-the-week-in-a-month">answer</a>并决定你想要哪个星期。</p>
<p>没有内置的,所以您需要使用apply计算它。例如,对于一个简单的“有多少个7天的周期已经过去”的度量。</p>
<pre><code>data['wom'] = data[0].apply(lambda d: (d.day-1) // 7 + 1)
</code></pre>
<p>对于更复杂的(基于日历),使用该答案中的函数。</p>
<pre><code>import datetime
import calendar
def week_of_month(tgtdate):
tgtdate = tgtdate.to_datetime()
days_this_month = calendar.mdays[tgtdate.month]
for i in range(1, days_this_month):
d = datetime.datetime(tgtdate.year, tgtdate.month, i)
if d.day - d.weekday() > 0:
startdate = d
break
# now we canuse the modulo 7 appraoch
return (tgtdate - startdate).days //7 + 1
data['calendar_wom'] = data[0].apply(week_of_month)
</code></pre>