Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Binning data to files
#1
Hi,
I am trying to develop a Power Curve / Algorithm that can give me a "Possible Max Power" signal when the Solar Panels on my roof are scaled-down in production.

To make this power curve I fetch data every second where I get a dataset similar to the below (Made with random.randint).
What would be a way I could separate this data into bins (Based on Solar_Radiation) so I can calculate a correlation between production and PV_Cell_Temp in each bin?
I have been looking around on the internet, but there doesn't seem to be anything in Pandas I can use to do this..

Timestamp,PV_Production,Solar_Radiation,PV_Cell_Temp,Ambient_Temp
2020-06-21 13:37:02.934901,0,206,164.8,0
2020-06-21 13:37:02.935898,0,312,124.8,0
2020-06-21 13:37:02.942879,0,234,23.4,0
2020-06-21 13:37:02.943877,0,230,230.0,0
2020-06-21 13:37:02.944874,0,273,218.4,0
2020-06-21 13:37:02.948862,0,317,95.1,0
2020-06-21 13:37:02.951855,0,328,328.0,0
2020-06-21 13:37:02.954847,0,311,0.0,0
Reply


Messages In This Thread
Binning data to files - by Kappel - Jun-21-2020, 06:04 PM
RE: Binning data to files - by Larz60+ - Jun-21-2020, 07:31 PM
RE: Binning data to files - by Kappel - Jun-22-2020, 02:30 PM
RE: Binning data to files - by Larz60+ - Jun-22-2020, 06:15 PM
RE: Binning data to files - by Kappel - Jun-22-2020, 06:25 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Ask for machine learning Python example with 2 data files user5566b 2 2,403 Sep-05-2019, 12:15 PM
Last Post: user5566b
  Need Help With Filtering Data For Excel Files Using Pandas eddywinch82 9 6,554 Aug-06-2019, 03:44 PM
Last Post: eddywinch82
  import/use data from text files MichealPeterson 1 3,418 Jun-28-2017, 08:51 AM
Last Post: buran

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020