如何从以下csv数据计算停车位的利用率 [英] How to calculate utilisation of parking space from the following csv data

问题描述

如何在python中编码以从以下数据计算停车位的利用率。 O代表占用，V代表空置。



时间，数量，状态



8:00:00 ，2，O



9：00：00,1，O



9:30:00 ，3，O



9:45：00,4，O



10:00:00 ，2，V



10：30：00,3，V



11:00:00 ，1，V



11：15：00,2，O



11:30:00 ，3，O



11：45：00,5，O



12:00:00 ，4，V



我的尝试：



i能够读取数据并执行操作。但我需要这个问题的帮助！

解决方案

这是你的作业，所以我不会给你任何代码！

开始通过数字将数据分组 - 我认为这是停车位号码并保持订购时间列。

当你这样做时，你将得到几组数据：

<前lang =text> 9：00：00,1，O
11：00：00,1，V

8：00：00,2 ，O
10：00：00,2，V
11：15：00,2，O

9：30：00,3，O
10 ：30：00,3，V
11：30：00,3，O

9：45：00,4，O
12：00：00,4， V

11：45：00,5，O

然后，您可以轻松计算出每个托架被占用以及何时它被释放。

在那之后，无论教师要求你在他设置的问题中收集什么数据，都会失败！

引用：

如何在python中编码以从以下数据计算停车位的利用率。

首先，你需要要理解这个问题，然后在纸上解决。

问题解决后，一步一步写下你使用的程序。

尝试解决问题按照程序，如果失败，请优化程序直到它工作。

你的程序是你的程序必须做的。

--------- -

我们不做你的家庭作业。

HomeWork不会在乞求别人做你的工作时测试你的技能，它会让你思考和帮助您的老师检查您对所学课程的理解，以及您应用这些课程时遇到的问题。

你的任何失败都会帮助你的老师发现你的弱点并设定补救措施。

所以，试一试，重读你的课程并开始工作。如果您遇到特定问题，请显示您的代码并解释这个问题，我们可能会提供帮助。



作为程序员，您的工作是创建算法解决特定问题，你不能依赖别人永远为你做，所以有一段时间你必须学会​​如何。而且越快越好。

当你要求解决方案时，就像试图通过培训其他人来学习开车一样。

创建算法基本上是找到数学并做出必要的调整以适应你的实际问题。

How to code in python for calculating utilisation of parking space from the following data. O represents occupied and V represents Vacant.

Time,Number,Status

8:00:00,2,O

9:00:00,1,O

9:30:00,3,O

9:45:00,4,O

10:00:00,2,V

10:30:00,3,V

11:00:00,1,V

11:15:00,2,O

11:30:00,3,O

11:45:00,5,O

12:00:00,4,V

What I have tried:

i was able to read the data and perform operations. But i need a help with this question!

解决方案

This is your homework, so I'll give you no code!
Start by grouping together data by "Number" - I presume this is "parking bay number" and keeping the Time column ordered.
When you do this, you will end up with several groups of data:

 9:00:00,1,O
11:00:00,1,V

 8:00:00,2,O
10:00:00,2,V
11:15:00,2,O

 9:30:00,3,O
10:30:00,3,V
11:30:00,3,O

 9:45:00,4,O
12:00:00,4,V

11:45:00,5,O

You can then easily work out when each bay is occupied and when it becomes free.
After that, it's down you whatever data the tutor asked you to gather in the question he set!

Quote:

How to code in python for calculating utilisation of parking space from the following data.

First, you need to understand the problem, then solve it on paper.
Once the problem is solved, write down the procedure you used, step by step.
Try to resolve the problem by just following the procedure, if it fail, refine the procedure until it work.
Your procedure is what your program must do.
----------
We do not do your HomeWork.
HomeWork is not set to test your skills at begging other people to do your work, it is set to make you think and to help your teacher to check your understanding of the courses you have taken and also the problems you have at applying them.
Any failure of you will help your teacher spot your weaknesses and set remedial actions.
So, give it a try, reread your lessons and start working. If you are stuck on a specific problem, show your code and explain this exact problem, we might help.

As programmer, your job is to create algorithms that solve specific problems and you can't rely on someone else to eternally do it for you, so there is a time where you will have to learn how to. And the sooner, the better.
When you just ask for the solution, it is like trying to learn to drive a car by having someone else training.
Creating an algorithm is basically finding the maths and make necessary adaptation to fit your actual problem.

这篇关于如何从以下csv数据计算停车位的利用率的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！