擅长:python、mysql、java
<p>对日期进行日期运算,不需要填写缺失的日期。然后按名称分组并计算天数。在</p>
<pre><code>from datetime import timedelta
data = pd.read_csv(StringIO('''Bobby, 101 1st Street, 9/1/2014, 9/3/2014'''),
names=['Name', 'Address', 'Start', 'End'], parse_dates=[2, 3])
#add a day to get the number of days inclusive
data["Days"] = (data.End - data.Start) + timedelta(days=1)
data.groupby('name').sum()["Days"]
</code></pre>