update samples from Release-112 as a part of SDK release

Merge pull request #1588 from Azure/release_update/Release-111
Update samples from Release-111 as a part of SDK 1.34.0 release
2021-09-24 21:40:44 +00:00 · 2021-09-09 09:02:38 -07:00
1 changed files with 10 additions and 2 deletions
--- a/how-to-use-azureml/machine-learning-pipelines/nyc-taxi-data-regression-model-building/scripts/prepdata/normalize.py
+++ b/how-to-use-azureml/machine-learning-pipelines/nyc-taxi-data-regression-model-building/scripts/prepdata/normalize.py
@@ -28,13 +28,21 @@ replaced_distance_vals_df = (replaced_stfor_vals_df.replace({"distance": ".00"},

 normalized_df = replaced_distance_vals_df.astype({"distance": 'float64'})

+
+def time_to_us(time_str):
+    hh, mm , ss = map(int, time_str.split(':'))
+    return (ss + 60 * (mm + 60 * hh)) * (10**6)
+
+
 temp = pd.DatetimeIndex(normalized_df["pickup_datetime"])
-normalized_df["pickup_date"] = temp.date
+normalized_df["pickup_date"] = pd.to_datetime(temp.date)
 normalized_df["pickup_time"] = temp.time
+normalized_df["pickup_time"] = normalized_df["pickup_time"].apply(lambda x: time_to_us(str(x)))

 temp = pd.DatetimeIndex(normalized_df["dropoff_datetime"])
-normalized_df["dropoff_date"] = temp.date
+normalized_df["dropoff_date"] = pd.to_datetime(temp.date)
 normalized_df["dropoff_time"] = temp.time
+normalized_df["dropoff_time"] = normalized_df["dropoff_time"].apply(lambda x: time_to_us(str(x)))

 del normalized_df["pickup_datetime"]
 del normalized_df["dropoff_datetime"]
Author	SHA1	Message	Date
amlrelsa-ms	c56c2c3525	update samples from Release-112 as a part of SDK release	2021-09-24 21:40:44 +00:00
Harneet Virk	4cac072fa4	Merge pull request #1588 from Azure/release_update/Release-111 Update samples from Release-111 as a part of SDK 1.34.0 release	2021-09-09 09:02:38 -07:00