0

i have a data resembling this

                                EndTime  Duration  PartsProduced
StartTime
                                                       
2020-09-03 00:14:51 2020-09-03 00:46:56      1925         9100.0
2020-09-03 00:53:09 2020-09-03 01:16:43      1414         6500.0
2020-09-03 01:18:45 2020-09-03 01:36:58      1093         4900.0
2020-09-03 01:38:56 2020-09-03 01:53:46       890         3700.0
2020-09-03 02:11:56 2020-09-03 02:15:41       225          500.0
2020-09-03 02:19:04 2020-09-03 02:39:47      1243         5600.0
2020-09-03 02:39:49 2020-09-03 03:10:12      1823         8100.0
2020-09-03 03:48:37 2020-09-03 03:59:59       682         3300.0
2020-09-03 04:00:00 2020-09-03 04:12:09       729         3100.0
2020-09-03 04:20:35 2020-09-03 04:23:12       157          300.0
2020-09-03 04:23:46 2020-09-03 04:32:32       526         1700.0
2020-09-03 04:35:54 2020-09-03 04:41:21       327         1000.0
2020-09-03 04:46:10 2020-09-03 05:11:58      1548         6900.0
2020-09-03 05:16:22 2020-09-03 05:30:56       874         3600.0
2020-09-03 05:44:24 2020-09-03 05:52:18       474         1500.0
2020-09-03 05:53:45 2020-09-03 05:58:31       286          900.0
2020-09-03 06:03:28 2020-09-03 06:05:22       114          100.0
2020-09-03 06:07:18 2020-09-03 06:10:12       174          500.0
2020-09-03 06:18:48 2020-09-03 06:21:50       182          100.0

I want to have Time in hourly manner, which splits both Duration and PartProduced in Ratios

      Hourly_DateTime  Duration  PartsProduced
0 2020-09-02 23:00:00       699         2700.0
1 2020-09-03 00:00:00      3339        15600.0
2 2020-09-03 01:00:00      1983         8600.0
3 2020-09-03 02:00:00      3291        14200.0
4 2020-09-03 03:00:00       682         3300.0
5 2020-09-03 04:00:00      3287        13000.0
6 2020-09-03 05:00:00      1634         6000.0
7 2020-09-03 06:00:00       470          700.0

I have tried to get the details using resample from Pandas.

g.set_index('StartTime', inplace=True)
k = g.resample('H').sum()
Improve this question
2
  • did the resample('H').sum() not give you the correct result? Commented Mar 27, 2023 at 14:15
  • datetime is splitted but duration is not splitted Commented Mar 27, 2023 at 18:43
Related questions
4240
How can I iterate over rows in a Pandas DataFrame?
3070
Renaming column names in Pandas
2331
Delete a column from a Pandas DataFrame
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.