Python For Data Science Tutorial Series

Topic: Variable and Operators

Check out our latest YouTube Video in which we have covered this very important topic that you must know very well.

Link👉🏻 https://youtu.be/8004kgAXWk0

Python For Data Science Tutorial Series

Topic: Strings in Python

Check out our latest YouTube Video in which we have covered this very important topic that you must know very well.

👉🏻https://youtu.be/X8qgKg8fNhk

Today's Interview QnAs

Company - The Math Company

Role- Data Analyst


1.How to create filters in Power BI?

Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways.

Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries.
Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters)


2.How to sort data in Power BI?

Sorting is available in multiple formats. In the data view, a common sorting option of alphabetical order is there. Apart from that, we have the option of Sort by column, where one can sort a column based on another column. The sorting option is available in visuals as well. Sort by ascending and descending option by the fields and measure present in the visual is also available.


3.How to convert pdf to excel?

Open the PDF document you want to convert in XLSX format in Acrobat DC.
Go to the right pane and click on the “Export PDF” option.
Choose spreadsheet as the Export format.
Select “Microsoft Excel Workbook.”
Now click “Export.”
Download the converted file or share it.


4. How to enable macros in excel?

Click the file tab and then click “Options.”
A dialog box will appear. In the “Excel Options” dialog box, click on the “Trust Center” and then “Trust Center Settings.”
Go to the “Macro Settings” and select “enable all macros.”
Click OK to apply the macro settings.

————————————————————-

🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.

This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!

Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo

Python For Data Science Tutorial Series

Topic: Conditional Statements (if-else in Python)

Check out our latest YouTube Video in which we have covered this very important topic that you must know very well.

👉🏻 https://youtu.be/4dmnTu_2Te8

Today's Interview QnAs

Company - Numerator

Role- Data Analyst


1.How to create filters in Power BI?

Filters are an integral part of Power BI reports. They are used to slice and dice the data as per the dimensions we want. Filters are created in a couple of ways.

Using Slicers: A slicer is a visual under Visualization Pane. This can be added to the design view to filter our reports. When a slicer is added to the design view, it requires a field to be added to it. For example- Slicer can be added for Country fields. Then the data can be filtered based on countries.
Using Filter Pane: The Power BI team has added a filter pane to the reports, which is a single space where we can add different fields as filters. And these fields can be added depending on whether you want to filter only one visual(Visual level filter), or all the visuals in the report page(Page level filters), or applicable to all the pages of the report(report level filters)


2. What is MDX in Power BI?

MDX is an Analysis Services Tabular capability that is basically used to help improve the user experience in Excel and various other applications that use MDX query language against the tabular form of the models and Power BI datasets. To have a hands-on the MDX, try it by deploying your datasets in Power BI and then connecting with Excel by using analyze in Excel, the new Power BI Datasets within Excel feature, or you can connect to this dataset on Power BI Premium as well through the XMLA endpoint.


3.How to convert numbers to words in excel in rupees?

Select a cell adjacent to the cell you want the currency (Rupees) to be converted into words.
Enter the formula – NumberstoWords(A1) and press Enter. A1 is the cell containing the currency in Rupees.
Press Enter to confirm the formula.


4.How to round off in excel?

You can use the ROUNDUP function to round off in Excel. Here is how –

Select a blank cell.
Use the ROUND function by entering the syntax – “=ROUNDUP(number,num_digits).
Where number denotes the number to round up and num_digits refers to a number of digits to which it should be rounded up.

Press Return.
Using the button, you can round off in Excel by following these steps –

Select the cells you want to round off.
Go to the Home tab, click Increase Decimal or Decrease Decimal.
Press Enter.

————————————————————-

🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.

This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!

Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo

Switch your career from any background to Data Science and Analytics.

Visit Our Course. Link Below 👇🏻

https://www.cloudyml.com/mega-combo-package/

Roadmap to Python. If you are someone who want to start with Python for Data Science then check out our latest YouTube Video. Link below

➡️ https://youtu.be/Qv4Jcs4-RE0

🚨Data Science Project Explanation Video

We have discussed Bike Sharing Demand Project (Kaggle Project) step by step with explanation in our latest YouTube Video. Check it Now. Link Below

👉🏻 https://youtu.be/6HVCuXrsQBs


NOTE: If our YouTube videos are helping you then please do like and share. Also subscribe to our channel and get regular contents related to Data Science and Analytics Domain.

Today's Interview QnAs

Company - Adecco

Role - Data Analyst


1.How to remove space in excel?

To remove extra spaces in Excel –

Press Ctrl+Space to select cells in a column.
Open the “Find & Replace” dialog box using the shortcut Ctrl+H.
In the “Find What” field, press the spacebar.
Leave the “Replace with” field empty.
Click on “Replace all” and press OK. All spaces will be removed.


2.How to calculate age in excel?

The easiest way to calculate age in MS Excel is using the formula –

“=DATEDIF(birth_date,as_of_date,”y”)”

The result will be the number of complete years.


3.What is Power BI Cloud?

Power BI Cloud is a Cloud-Based Data Visualization set-up that gives access to its users for editing, viewing, creating, and sharing the dashboards’ reports & datasets across organizations and a group of people by protecting the Admin Rights & Credentials. Access is required to view & edit these reports & dashboards.


4. How to combine two columns in Power BI?

To combine two columns in Power BI, you need to select a new calculated column using the DAX expression.

For example, if you need to add the values of two columns & make the third column, then you can do it by the Following DAX Expression:

Total=Sheet Name(Col1) +sheet Name(Col2). In the image below, two text columns City & State, are added & concatenated to one new column. In the same way, you can add Numeric columns using DAX.

————————————————————-

🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.

This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!

Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo

A career transition roadmap which is chosen and trusted by more than 6000 people with 1300+ Success Stories.

Join today and start your Data Science and Analytics Journey from scratch.

Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo

Quantitative Aptitude Problem with Explained Solution.

Check out our latest YouTube Video in which we have covered some aptitude test question and explained the solution. Link Below

➡️https://youtu.be/FM4JluvpXic

SQL interview question asked in TCS. Check explained solution video on our YouTube channel. Link Below.

Check Now➡️https://youtu.be/nQaEcDVpNG0


🔴Subscribe our YouTube channel to get Data Science and Analytics interview questions with explained solution videos and Data science explained Projects

Today's Interview QnAs

Company- IBM

Role- Data Analyst


1.What is a heatmap? Give an example.

A heatmap is a type of visualization used to demonstrate a set of data through varying shades of colours where the darkest shade of a specific colour denotes an extreme value (high intensity/density). It is typically used to compare two or more measures.

A quick example of a heatmap would be to understand the anatomy of the human body and observe the level of warmth depending upon the temperature of specific organs. If the red-yellow combination of colours is used, the areas that show red will denote the maximum temperature.


2. What is DRIVE Program Methodology?

It is a product of iterative sessions previously used and tested by enterprise deployments. It is based on best practises and allows a user to follow a specific set of actions to avoid errors and expedite reporting or visualization process.


3. When does regularization come into play in Machine Learning?

At times when the model begins to underfit or overfit, regularization becomes necessary. It is a regression that diverts or regularizes the coefficient estimates towards zero. It reduces flexibility and discourages learning in a model to avoid the risk of overfitting. The model complexity is reduced and it becomes better at predicting.


4. What is the order of operations in Excel?

Excel follows PEMDAS: parentheticals, exponents, multiplication, division, addition, and then subtraction. If you type in “=1+2/4” the answer will be 3/2 rather than ¾.

————————————————————-

🔴If you wanna switch your career from any domain to Data Science OR Data Analytics OR Business Analytics then check our MEGA COMBO COURSE PACKAGE.

This course package, you are getting Python, SQL, Statistics, Machine Learning, Deep Learning, AWS Sagemaker, Model Deployment, Tableau, PowerBi, Excel, Case studies, Capstone End-to-End Projects of ML and DL with 1-1 Live Doubt Clearance Support over Skype chat everyday. Check the course NOW!

Course Link👉🏻 https://ai.cloudyml.com/Mega-Combo

Today's Interview QnAs

Company- Cloudera

Role: Data Scientist


1.What is covariance?

Covariance signifies the direction of the linear relationship between the two variables. By direction we mean if the variables are directly proportional or inversely proportional to each other. (Increasing the value of one variable might have a positive or a negative impact on the value of the other variable).

The values of covariance can be between -infinity to +infinity.


2.How can you calculate the p-value using MS Excel?

The formula used in MS Excel to calculate p-value is –

=tdist(x,deg_freedom,tails)

The p-value is expressed in decimals in Excel. Here are the steps to calculate it –

-Find the Data tab
On the Analysis tab, click on the data analysis icon

-Select Descriptive Statistics and then click OK

-Select the relevant column
Input the confidence level and other variables


3. What is formula of exponential smoothing?

The simplest form of an exponential smoothing formula is given by:

st = αxt+(1 – α)st-1= st-1+ α(xt – st-1)

Here,

st = smoothed statistic, it is the simple weighted average of current observation xt

st-1 = previous smoothed statistic

α = smoothing factor of data; 0 < α < 1

t = time period

If the value of the smoothing factor is larger, then the level of smoothing will reduce. Value of α close to 1 has less of a smoothing effect and give greater weight to recent changes in the data, while the value of α closer to zero has a greater smoothing effect and are less responsive to recent changes.


4. Consider a small unit of a factory where there are 5 employees : a supervisor and four labourers. The workers earn a salary of Rs. 5,000 per month each while the supervisor gets Rs. 15,000 per month. Calculate the mean, median and mode of the salaries.

Mean = (5000 + 5000 + 5000 + 5000 + 15000)/5 = 35000/5 = 7000

So, the mean salary is Rs. 7000 per month

To obtain the median, let us arrange the salaries in ascending order:

5000, 5000, 5000, 5000, 15000

Median = (n+1)/2 = (5+1)/2 = 6/2 = 3rd observation

Median = Rs. 5000/-

Mode = Number of times an observation is repeated = Rs.5000/