Hi there,

I am new here and I require help analyzing a set of data that I have.

This dataset is a list of train journeys for a certain time period on a particular day in a country. Each line in the dataset consists of five fields:

1. a unique journey ID
2. destination station
3. time when the commuter tapped out of the station
4. origin station
5. time when the commuter tapped into the station

What methods shall I use and codes to write to find out the following?

1. What is the underlying train network according to the dataset provided?
2. How many trains are there from any station to another station during that time frame?
3. Suppose a commuter wants to board a train at Clementi Station at 9:25am and heads to Kallang Station, how many people are there in the train at every station along the journey from Clementi Station to Kallang Station, starting from 9:25am?

Would really really appreciate it if someone can help me with this problem.

Thank you so much!!!

Regards,

Esther