Assignment of AI and data science

🖥️🖥️ 🖥️ VLOOKUP function in Excel   The   VLOOKUP function   is one of the most popular functions in   Excel . This page contains many easy to follow VLOOKUP examples. Exact Match Most of the time you are looking for an exact match when you use the VLOOKUP function in Excel. Let's take a look at the arguments of the VLOOKUP function. 1. The VLOOKUP function below looks up the value Anaya (first argument) in the leftmost column of the red table (second argument). 2. The value 2 (third argument) tells the VLOOKUP function to return the value in the same row from the second column of the red table. Note: the Boolean FALSE (fourth argument) tells the VLOOKUP function to return an exact match. If the VLOOKUP function cannot find the value Anaya in the first column, it will return a  #N/A error . 3. Here's another example. Instead of returning the roll no, the VLOOKUP function below returns the last name (third argument is set to 3) of Anaya = 4004. Full  form...

  Using Flash Fill Step-by-step guide in using flash fill. Go to the Data tab in your worksheet, you will find an option called Flash Fill.    Step 2: If all the first name and last name are combined in the data. then we use flash fill to separate the first name and last name in different columns. Step 3:- In next column write first name and then write only first name Step 4:- use shortcut key CTRL+E  Similarly, fill the data in the  Last Name  Column using the Flash Fill method.   FINAL OUTPUT

      Text to Columns in Excel   To separate the contents of one  Excel cell  into  separate columns , you can use the 'Convert Text to Columns Wizard'. For example, when you want to separate a list of full names into last and first names. 1. Select the range with full names. 2. On the Data tab, in the Data Tools group, click Text to Columns. The following dialog box appears. 3. Choose Delimited and click Next. 4. Clear all the check boxes under Delimiters except for the Comma and Space check box. 5. Click Finish. Note: This example has commas and spaces as delimiters. You may have other delimiters in your data. Experiment by checking and unchecking the different check boxes. You get a live preview of how your data will be separated. Result:  

  How to make pivot table   Step 1: Prepare Your Data Organize Data :  Make sure your data is in a tabular format. Each column should have a header, and there should be no blank rows or columns within the dat a. Check for Consistency :  Ensure that the data types in each column are consistent (e.g., numbers in a number column, dates in a date column). Step 2: Select Your Data Highlight the Data :  Click and drag to select the range of data you want to include in the Pivot Table. You can also click anywhere within the data range. Step 3: Insert the Pivot Table Go to the Ribbon :  Click on the  Insert  tab in the Excel ribbon at the top of the window. Select Pivot Table :  Click on the  PivotTable  button. This will open the Create PivotTable dialog box. Step 4: Choose Pivot Table Options Select Data Range :  In the dialog box, Excel will automatically select the data range. You can adjust it if necessary. Choose Location : ...

Remove duplicate data 1. Go to data option  in menu bar. 2. Select the data in which you want to remove duplicate items. 3. select the duplicate remove option which is situated next to the columns. Then dialogue box will appear which is shown following below :- OUTPUT:- If condition formula In Excel, you can use the IF function to perform conditional logic. The basic syntax is: = IF (logical test, value_if_true, value_if_false) logical test: The condition you want to evaluate (e.g., A1 > 10). value_if_true : The value that will be returned if the condition is true. value_if_false : The value that will be returned if the condition is false. Example 1: = IF (A1 > 10 , "Yes" , "No" ) If you want to check if the value in cell A1 is greater than 10, and return "Yes" if it is, or "No" if it isn't: Example 2: If you want to check if the value in A1 is greater than 50, and return "High" if true, or "Low" if false, you can d...

😊😊Data validation for error message😊😊 1. Click on data option in menu bar. 2. Select data tools then go to setting. 3.Choose whole number from drop list. 4. Fill the maximum number. 5. Fill the minimum number. 6. Fill title under error alert option.   OUTPUT   figure1:- figure 2:-  figure 3:-