Hey Folks

Our Popular Data Science in on SUPER DISCOUNT today and this offer will end by 11:59PM (IST)

You still have chance to grap this opportunity.

Regular price: ₹3499/-

Today's Price: ₹999/-

You still have 2 Hours.

Don't Miss this Offer

Get hands on practical learning experience with one one course support mentorship.

Discount Link: https://www.cloudyml.com/ai-for-all-discount/

#LearnByDoing

https://youtu.be/tBdu-JZyANo

Finally a video with my face and nice editing 😁

Date: 27-04-2023
Company name: TCS
Role: Data Analyst
Topic : data cleaning, data wrangling, cte

1. Define the term 'Data Wrangling.

Data Wrangling is the process wherein raw data is cleaned, structured, and enriched into a desired usable format for better decision making. It involves discovering, structuring, cleaning, enriching, validating, and analyzing data. This process can turn and map out large amounts of data extracted from various sources into a more useful format.

2. What are the best methods for data cleaning?

Create a data cleaning plan by understanding where the common errors take place and keep all the communications open. Before working with the data, identify and remove the duplicates. This will lead to an easy and effective data analysis process.Focus on the accuracy of the data. Set cross-field validation, maintain the value types of data, and provide mandatory constraints.Normalize the data at the entry point so that it is less chaotic. You will be able to ensure that all information is standardized, leading to fewer errors on entry.


3. Explain 4 steps to use CTE in sql.

All CTE starts with "with" clause.

After with you need to define CTE name and the field names. For instance in the below code snippet I have 3 fields Count,Column and Id. The name of CTE is "MyTemp".

Once you have defined CTE we need to specify the SQL which will give the result for the CTE.

Finally you can use the CTE in your SQL query.


#Learnbydoing

Date: 28-04-2023
Company name: Infosys
Role: Data Scientist
Topic: LSTM, kmeans, cte, numpy

1. Can you explain how the memory cell in an LSTM is implemented computationally?

The memory cell in an LSTM is implemented as a forget gate, an input gate, and an output gate. The forget gate controls how much information from the previous cell state is forgotten. The input gate controls how much new information from the current input is allowed into the cell state. The output gate controls how much information from the cell state is allowed to pass out to the next cell state.


2. What is CTE in SQL?

A CTE (Common Table Expression) is a one-time result set that only exists for the duration of the query. It allows us to refer to data within a single SELECT, INSERT, UPDATE, DELETE, CREATE VIEW, or MERGE statement's execution scope. It is temporary because its result cannot be stored anywhere and will be lost as soon as a query's execution is completed.


3. List the advantages NumPy Arrays have over Python lists?

Python’s lists, even though hugely efficient containers capable of a number of functions, have several limitations when compared to NumPy arrays. It is not possible to perform vectorised operations which includes element-wise addition and multiplication. They also require that Python store the type information of every element since they support objects of different types. This means a type dispatching code must be executed each time an operation on an element is done.

4. Explain some cases where k-Means clustering fails to give good results

k-means has trouble clustering data where clusters are of various sizes and densities.
Outliers will cause the centroids to be dragged, or the outliers might get their own cluster instead of being ignored. Outliers should be clipped or removed before clustering.
If the number of dimensions increase, a distance-based similarity measure converges to a constant value between any given examples. Dimensions should be reduced before clustering them.

👉🏻 #Learnbydoing

Most in-demand #Datasets for #NLP. Check This Post 👇🏻

https://www.linkedin.com/posts/akashraj001_datasets-nlp-chatgpt-activity-7059755512820547585-P3sr?utm_source=share&utm_medium=member_desktop

This Independence Day, let’s celebrate the spirit of growth, knowledge, and endless possibilities with CloudyML


#LearnByDoing