Understanding Pandas Date Range and DataFrame Index

Using Conditional Aggregation to Combine SQL Queries and Calculate Differences