Subject: Determining the sinuosity index of the streets (With explanations)
Posted: Thu Jun 02, 2022 8:02 am
Subject: Determining the sinuosity index of the streets
(With explanations)
Subject: Determining the sinuosity index of the streets (with explanations) 1. Open "Table_StudentID.xlsx" excel file in a Spyder editor as a pandas data frame. While each line represents a street, the columns represent the attributes of regarding the streets: STREET_ID, LENGTH, XS, YS, Xe, Ye. 2. Compute the straight distances of the streets (between the start and end points of the streets) using the Euclidean formula below and place the distance values into a new column titled as 'STRAIGHT': Distance_straight = √(Xe − Xs)² + (Ye - Ys)² 3. Compute the sinuosity of the streets using the formula below and place the sinuosity values into a new column titled as 'SINUOSITY': Sinuosity = LENGTH STRAIGHT 4. Classify the sinuosity values of the streets as 'LOW' (if it is less than 1.25), 'MID' (if it is greater than or equal to 1.25, and less than 1.75), and 'HIGH' (if it is greater than or equal to 1.75). Also, place the classification of sinuosity index into a new column titled as 'SIN_INDEX'. 5. Plot the sorted sinuosity values as a simple line graph. 6. Export the data frame as an excel file titled 'StudentID.xlsx'. 7. Zip the three outputs (below) as a .zip or .rar file and upload the zipped file into the online course system (online.yildiz.edu.tr) until 5th of June 2022: I. The Python codes of the work titled as 'StudentlD.py' II. The exported excel file titled as 'StudentID.xlsx' III. The sinuosity graph as a jpeg file titled as 'StudentID.jpeg'
(With explanations)
Subject: Determining the sinuosity index of the streets (with explanations) 1. Open "Table_StudentID.xlsx" excel file in a Spyder editor as a pandas data frame. While each line represents a street, the columns represent the attributes of regarding the streets: STREET_ID, LENGTH, XS, YS, Xe, Ye. 2. Compute the straight distances of the streets (between the start and end points of the streets) using the Euclidean formula below and place the distance values into a new column titled as 'STRAIGHT': Distance_straight = √(Xe − Xs)² + (Ye - Ys)² 3. Compute the sinuosity of the streets using the formula below and place the sinuosity values into a new column titled as 'SINUOSITY': Sinuosity = LENGTH STRAIGHT 4. Classify the sinuosity values of the streets as 'LOW' (if it is less than 1.25), 'MID' (if it is greater than or equal to 1.25, and less than 1.75), and 'HIGH' (if it is greater than or equal to 1.75). Also, place the classification of sinuosity index into a new column titled as 'SIN_INDEX'. 5. Plot the sorted sinuosity values as a simple line graph. 6. Export the data frame as an excel file titled 'StudentID.xlsx'. 7. Zip the three outputs (below) as a .zip or .rar file and upload the zipped file into the online course system (online.yildiz.edu.tr) until 5th of June 2022: I. The Python codes of the work titled as 'StudentlD.py' II. The exported excel file titled as 'StudentID.xlsx' III. The sinuosity graph as a jpeg file titled as 'StudentID.jpeg'