Скачать или смотреть Bin data frame and calculate average

Hello everyone! I hope this video has helped solve your questions and issues. This video is shared because a solution has been found for the question/problem. I create videos for questions that have solutions. If you have any other issues, feel free to reach out to me on Instagram:   / ky.emrah  

Below, you can find the text related to the question/problem. In the video, the question will be presented first, followed by the answers. If the video moves too fast, feel free to pause and review the answers. If you need more detailed information, you can find the necessary sources and links at the bottom of this description. I hope this video has been helpful, and even if it doesn't directly solve your problem, it will guide you to the source of the solution. I'd appreciate it if you like the video and subscribe to my channel!Bin data frame and calculate average

I have data which contains position in one column and values in other columns. I wanted to plot a line graph by binning the rows. there are more than 50,000 rows, so i want to bin data in to 50 bins and calculate average for values in the columns.
Here is my input sample data.
position sample_1 sample_2 sample_3 sample_4
1001 21 43 28 35
1002 22 42 29 38
1003 23 46 23 42
1004 26 43 26 46
1005 31 31 31 43
1006 26 35 26 31
1007 18 36 24 35
1008 19 37 23 39
1009 21 34 22 23
1010 31 24 21 26
1011 32 23 20 31
1012 34 36 22 26
1013 25 43 23 25
1014 27 42 26 27
1015 26 46 26 26
1016 35 47 31 28

position sample_1 sample_2 sample_3 sample_4
1001 21 43 28 35
1002 22 42 29 38
1003 23 46 23 42
1004 26 43 26 46
1005 31 31 31 43
1006 26 35 26 31
1007 18 36 24 35
1008 19 37 23 39
1009 21 34 22 23
1010 31 24 21 26
1011 32 23 20 31
1012 34 36 22 26
1013 25 43 23 25
1014 27 42 26 27
1015 26 46 26 26
1016 35 47 31 28

The output i am looking for is after binning sample data in to 4 columns and data is averaged for other samples.
The output i am expecting from sample data is
Bin sample_1 sample_2 sample_3 sample_4
1001-1004 23 43.5 26.5 40.25
1005-1008 23.5 34.75 26 37
1009-1012 29.5 29.25 21.25 26.5
1013-1016 28.25 44.5 26.5 26.5

Bin sample_1 sample_2 sample_3 sample_4
1001-1004 23 43.5 26.5 40.25
1005-1008 23.5 34.75 26 37
1009-1012 29.5 29.25 21.25 26.5
1013-1016 28.25 44.5 26.5 26.5



Tags: python,pandas,dataframe,numpySource of the question:
https://stackoverflow.com/questions/7...

Question and source license information:
https://meta.stackexchange.com/help/l...
https://stackoverflow.com/