Question

UPDATED:
Hi, I have a problem in PYTHON I've been trying to solve. I'm given two csv files containing data in the following format of a micro car that moves around:

Action, time, speed. (e.g. N,t,s= Move North for t seconds with speed s meters per second)

One list is the expected results, the second list is the actual (recorded) results.

The car can move N,S,E,W. The data entry will look like this: (CSV files)

Expected:
N 10 18 S 10 16 W 95
Actual:

I am trying to get the function to return:

The expected horizontal displacements for each microcar • The expected vertical displacements for each microcar • The actual horizontal displacements for each microcar • The actual vertical displacements for each microcar • The expected distances travelled by each microcar • The actual distances travelled by each microcar

All in numpy arrays. Could someone please show me a test solution, Thank you

Answer 1

import numpy as np

# expected data is in expected.csv and actual data is in actual.csv

exp = np.genfromtxt("expected.csv", delimiter=",", usecols=(1,2)) # read csv into numpy array
actual = np.genfromtxt("actual.csv", delimiter=",", usecols=(1,2)) # usecols=(1,2) used to read 1st and 2nd column, skipping N,E,S,W variables while reading

print("Expected horizontal displacement foar each microcar")
print(exp[1][0]*exp[1][1] - exp[3][0]*exp[3][1])

print("Expected vertical displacement foar each microcar")
print(exp[0][0]*exp[0][1] - exp[2][0]*exp[2][1])

print("Actual horizontal displacement foar each microcar")
print(actual[1][0]*actual[1][1] - actual[3][0]*actual[3][1])

print("Actual vertical displacement foar each microcar")
print(actual[0][0]*actual[0][1] - actual[2][0]*actual[2][1])

print("Expected distances travelled by each microcar")
print(exp[0][0]*exp[0][1]+exp[1][0]*exp[1][1]+exp[2][0]*exp[2][1]+exp[3][0]*exp[3][1])

print("Actual distances travelled by each microcar")
print(actual[0][0]*actual[0][1]+actual[1][0]*actual[1][1]+actual[2][0]*actual[2][1]+actual[3][0]*actual[3][1])