Posts

Showing posts from April, 2021

Engineer Data in Google Cloud :Challenge Lab | Qwiklabs | Google Cloud Platform [SOLUTIONS]

Lab Name:-  Engineer Data in Google Cloud :Challenge Lab   Open BigQuery Editor and enter all the three comands one by one :- QUERY-1 ------------------------------------------------------------------------ CREATE OR REPLACE TABLE   taxirides.taxi_training_data AS SELECT   (tolls_amount + fare_amount) AS fare_amount,   pickup_datetime,   pickup_longitude AS pickuplon,   pickup_latitude AS pickuplat,   dropoff_longitude AS dropofflon,   dropoff_latitude AS dropofflat,   passenger_count AS passengers, FROM   taxirides.historical_taxi_rides_raw WHERE   RAND() < 0.001   AND trip_distance > 0   AND fare_amount >= 2.5   AND pickup_longitude > -78   AND pickup_longitude < -70   AND dropoff_longitude > -78   AND dropoff_longitude < -70   AND pickup_latitude > 37   AND pickup_latitude < 45   AND dropoff_latitude > 37   AND dropoff_latitude < 45   AND...

Palindrome Python Program

Image
  PALINDROME PYTHON PROGRAM Python program to check whether a given string is PALINDROME or not? string = input (" Enter your String:- ") reverse = string[::-1] if string == reverse:     print (" String is Palindrome ") else :     print (" String is not Palindrome ") VIDEO SOLUTION:-

Perform Foundational Data, ML, and AI Tasks in Google Cloud: Challenge Lab

Perform Foundational Data, ML, and AI Tasks in Google Cloud: Challenge Lab TASK 4 Run these commands on your Google Cloud Shell:- ############################################################################# gcloud iam service-accounts create my-natlang-sa --display-name "my natural language service account" gcloud iam service-accounts keys create ~/key.json --iam-account my-natlang-sa@${GOOGLE_CLOUD_PROJECT}.iam.gserviceaccount.com export GOOGLE_APPLICATION_CREDENTIALS="/home/$USER/key.json" gcloud auth activate-service-account my-natlang-sa@${GOOGLE_CLOUD_PROJECT}.iam.gserviceaccount.com --key-file=$GOOGLE_APPLICATION_CREDENTIALS gcloud ml language analyze-entities --content="Old Norse texts portray Odin as one-eyed and long-bearded, frequently wielding a spear named Gungnir and wearing a cloak and a broad hat." > result.json gcloud auth login gsutil cp result.json gs://$GOOGLE_CLOUD_PROJECT-marking/task4-cnl.result ###################################...

Create ML Models with BigQuery ML: Challenge Lab

Image
LAB CODE:-  GSP341 LAB NAME:- Create ML Models with BigQuery ML: Challenge Lab Task 1: Create a dataset to store your machine learning models Open Cloud Shell Terminal and run the following command:- ############################################################################# bq mk austin ############################################################################# Task 2: Create a forecasting BigQuery machine learning model Open  BigQuery Console Query Editor   and run the following command:- ############################################################################# CREATE OR REPLACE MODEL austin.location_model OPTIONS   (model_type='linear_reg', labels=['duration_minutes']) AS SELECT     start_station_name AS location,     EXTRACT(HOUR FROM start_time) AS start_hour,     EXTRACT(DAYOFWEEK FROM start_time) AS day_of_week,     duration_minutes, FROM     `bigquery-public-data.austin_bikeshare.bikeshare_t...

🔰 How to Make Websites Load Fast In Google Chrome On Android

✅ The method is very simple and we will be editing some hidden features of Chrome in this method and with that, your Chrome speed will boost up and it will browse web pages faster. So follow up the below steps to proceed. 🌀 Steps To Make Google Chrome Browse Faster In Your Android 💠 Turn On The Data Saver ⚜️ Well if you turn on this option then it will send data to Google’s servers to be compressed and optimized for a better browsing experience. So, this could be another useful feature that can definitely improve your browsing experience. This not only makes your browsing a bit faster, but it will also help to cut down on data consumption. ⚜️ For enabling the data saver in Google Chrome for Android, hit the 3-dot menu button that is on the top-right corner of the screen> Settings> Data saver> Enable it. 💠 Kill the cache ⚜️ Cache is actually a good thing it helps to browse web pages much faster. However, the problem arises when you have too much cache data store, as the file...