def get_trip_counts_per_day(self):
query = "<STR_LIT>"<EOL>trip_counts_per_day = pd.read_sql_query(query, self.conn, index_col="<STR_LIT:date>")<EOL>max_day = trip_counts_per_day.index.max()<EOL>min_day = trip_counts_per_day.index.min()<EOL>min_date = datetime.datetime.strptime(min_day, '<STR_LIT>')<EOL>max_date = datetime.datetime.strptime(max_day, '<STR_LIT>')<EOL>num_days = (max_date - min_date).days<EOL>dates = [min_date + datetime.timedelta(days=x) for x in range(num_days + <NUM_LIT:1>)]<EOL>trip_counts = []<EOL>date_strings = []<EOL>for date in dates:<EOL><INDENT>date_string = date.strftime("<STR_LIT>")<EOL>date_strings.append(date_string)<EOL>try:<EOL><INDENT>value = trip_counts_per_day.loc[date_string, '<STR_LIT>']<EOL><DEDENT>except KeyError:<EOL><INDENT>value = <NUM_LIT:0><EOL><DEDENT>trip_counts.append(value)<EOL><DEDENT>for date_string in trip_counts_per_day.index:<EOL><INDENT>assert date_string in date_strings<EOL><DEDENT>data = {"<STR_LIT:date>": dates, "<STR_LIT>": date_strings, "<STR_LIT>": trip_counts}<EOL>return pd.DataFrame(data)<EOL>
Get trip counts per day between the start and end day of the feed.

Returns
-------
trip_counts : pandas.DataFrame
    Has columns "date_str" (dtype str) "trip_counts" (dtype int)