Learn how you can build Big Data Projects
How to Lock Down a cell ?
In VLookUp Example when we use that formula in a cell and when we drag formula to other cells, we need to lock down the copied cell...how to perform that lock
Oct 20 2013 11:48 AM
Suppose you want to lock down D4. Place the curosor between "D" and "4" and press F4 key. 2 $ signs will appear and it will look like $d$4 - this will lock down the cell.
Oct 21 2013 03:25 PM
This will lock down both the row and column.
In some scenarios you might have to lock down only the row or only the column. In that case, keep pressing F4 until the $ sign changes places.
Oct 21 2013 03:26 PM
Build an Image Classifier for Plant Species Identification
In this machine learning project, we will use binary leaf images and extracted features, including shape, margin, and texture to accurately identify plant species using different benchmark classification techniques.
Perform Time series modelling using Facebook Prophet
In this project, we are going to talk about Time Series Forecasting to predict the electricity requirement for a particular house using Prophet.
Event Data Analysis using AWS ELK Stack
This Elasticsearch example deploys the AWS ELK stack to analyse streaming event data. Tools used include Nifi, PySpark, Elasticsearch, Logstash and Kibana for visualisation.
Identifying Product Bundles from Sales Data Using R Language
In this data science project in R, we are going to talk about subjective segmentation which is a clustering technique to find out product bundles in sales data.
Machine Learning project for Retail Price Optimization
In this machine learning pricing project, we implement a retail price optimization algorithm using regression trees. This is one of the first steps to building a dynamic pricing model.
Finding Unique URL's using Hadoop Hive
Hive Project -Learn to write a Hive program to find the first unique URL, given 'n' number of URL's.
Real-Time Log Processing in Kafka for Streaming Architecture
The goal of this apache kafka project is to process log entries from applications in real-time using Kafka for the streaming architecture in a microservice sense.
Data processing with Spark SQL
In this Apache Spark SQL project, we will go through provisioning data for retrieval using Spark SQL.
Predict Employee Computer Access Needs in Python
Data Science Project in Python- Given his or her job role, predict employee access needs using amazon employee database.
Customer Churn Prediction Analysis using Ensemble Techniques
In this machine learning churn project, we implement a churn prediction model in python using ensemble techniques.
in vlookup, how do you lock the formula?
How do i lock down the values when using VLOOKUP Function?
How to use VLOOKUP?
Can we use VLOOKUP for geting data from two different excel?
for Vloop up function how to lock value in table_array parameter using keyboard shortcut?
You have not activated your email address. We have emailed you an activation code - please enter it below