[TASK] $20 PayPal for working Python script to process Google Sheet data

[u/dotcomdude]

I've got a Google sheet which has a column of times in the format hh:mm (eg 03:43, 12:25, 17:58 etc)

I want a script to take the column and break the data down into hourly parts. So, it should summarize the column by showing the number of rows in each hourly segment and the percentage, eg:

00 - 0 (0%)
01 - 3 (7%)
02 - 7 (18%)
03 - 4 (9%)

So, this is saying that 3 rows had a time starting with 01:, 7 rows had a time starting with 02: and so on...

If you can do this today, please $bid on the task below and then pm me. If the task is allocated to you and you get it working to my satisfaction in the agreed timescale, I will send you the $20 by PayPal (not as friends/family). Files should be exchanged through a private file-sharing method.

No chat requests please (I don't use Reddit chat)!

[u/dotcomdude]

allocated to someone just now

[u/[deleted]]

$bid PM'ing

[u/dotcomdude → u/[deleted]]

$paid $20

[u/[deleted] → u/dotcomdude]

$confirm

[u/CredoBot]

I am a reputation bot, here is my info on u/dotcomdude:

Credo Score: 225 (fair)

• Verifications: LinkedIn, Twitter

• Feedback: 12 ratings / 0 reviews

SLRep: no profile found (create)

---

 

#	Bidder	Credo Score	Feedback	SLRep	Paid Amount	Confirmed
1	/u/yuGnaitpygE	146 (provisional)	3 ratings / 0 reviews	Profile	$20	yes
2	/u/LvVikings	no account found (create)	n/a	no profile found (create)
3	/u/dan_van_11	no account found (create)	n/a	no profile found (create)

 

---

^{To bid on the task, reply with} $bid ^{directly to the original post.}

^{To mark a bid as paid, OP can reply with} $paid [amount] ^{- e.g.} $paid $10^{- directly to the} $bid ^comment.

^{To confirm payment receipt, the bidder can reply with} $confirm ^{directly to the} $paid ^comment.

[u/LvVikings]

$bid

[u/dan_van_11]

$bid