Is there a way to sum a list based on another list?

by

This might help get you started on accomplishing your ultimate goal:

Date = ['01-01-2019', '02-01-2019', '02-01-2019']

Time = ['07:00:00', '06:00:00','02:00:00']

import datetime

data = zip(Date, Time)

dates = []

for d in data:
    dt = datetime.datetime.strptime("{}, {}".format(*d), "%m-%d-%Y, %H:%M:%S")
    dates.append(dt)

totals = {}
for d in dates:
    if d.date() not in totals: totals[d.date()] = d.hour
    else: totals[d.date()] += d.hour

for date, time in totals.items():
    if time >= 8:
        # do something
        print('do something:', date)
    else:
        print('do something else.')

More Related Contents:

  1. Reading data from txt file only reads last line [closed]
  2. python spaces error [closed]
  3. Python method for any integer returns a list consisting of numbers 5 and 7 only
  4. Check if a given key already exists in a dictionary
  5. How to find list intersection?
  6. Can I redirect the stdout into some sort of string buffer?
  7. How accurate is python’s time.sleep()?
  8. Using sudo with Python script
  9. Check if a file is not open nor being used by another process
  10. Python argparse – Add argument to multiple subparsers
  11. Longest common substring from more than two strings
  12. Python: Open file in zip without temporarily extracting it
  13. How to open multiple webpages in separate tabs within a browser using selenium-webdriver and python
  14. Count consecutive characters
  15. How should I use the Optional type hint?
  16. join two lists of dictionaries on a single key
  17. In Python, how do I iterate over a dictionary in sorted key order?
  18. shuffle string in python
  19. Difference between dict.clear() and assigning {} in Python
  20. Comparing floats in a pandas column
  21. Python – Converting XLSX to PDF
  22. Flattening a list recursively [duplicate]
  23. Environment Variables when script run by cron
  24. Why is `with open()` better for opening files in Python?
  25. Understanding NumPy’s Convolve
  26. Add “django-admin.py” path to command line on Windows 7
  27. Color a scatter plot by Column Values
  28. What are assignment expressions (using the “walrus” or “:=” operator)? Why was this syntax added?
  29. Convert Tweepy Status object into JSON
  30. Can Syntax Errors be handled?

Leave a Comment