Substituting characters

In this exercise, you'll be using your text manipulation skills to create standardized URLs for each film in the table.

These URLs must have three parts: www., the Film URL Slug, and -film.com.

For example, the URL forDoctor Strange would be:

www.doctor-strange-film.com

यह अभ्यास पाठ्यक्रम का हिस्सा है

Google Sheets में डेटा विश्लेषण

पाठ्यक्रम देखें

अभ्यास निर्देश

In A14:A23, remove any colons from the film titles by replacing them with an empty string.
In C14:C23, create the Film URL Slug by replacing the spaces in A14:A23 with dashes (-), and making all text lowercase.
In E14:E23, create the Film Website by adding www. to the beginning of Film URL Slug and -film.com to the end.

इंटरैक्टिव व्यावहारिक अभ्यास

हमारे इंटरैक्टिव अभ्यासों में से किसी एक के साथ सिद्धांत को व्यवहार में बदलें

अभ्यास शुरू करें

यह अभ्यास पाठ्यक्रम का हिस्सा है

Google Sheets में डेटा विश्लेषण

SkillTag.level.beginnerSkillTag.label

4.8+

पाठ्यक्रम मुफ्त में शुरू करें

Learn how data analyst skills in spreadsheets can help you draw clearer insights from data. In this chapter, you'll learn how built-in functions can streamline your spreadsheet workflows and improve the readability of your formulas. You'll learn data exploration techniques, such as calculating summary statistics and manipulations like sorting and filtering.

Exercise 1: Built-in functions Exercise 2: The data analysis way!Exercise 3: Rounding values Exercise 4: Summary statistics Exercise 5: Measures of center Exercise 6: Counting cells Exercise 7: Sorting and filtering Exercise 8: How big are Jupiter's moons?Exercise 9: Bringing order to the universe!

It is often said that data professionals spend 80% of their time cleaning data and only 20% analyzing it. In this chapter, you'll learn useful functions for cleaning text and DateTime data, two of the trickiest data types to clean. You'll extract date and time components, calculate intervals, and perform a host of common text manipulations on a dataset of the highest-grossing films.

Exercise 1: Extracting date and time components Exercise 2: Extracting years and months Exercise 3: Extracting weekday components Exercise 4: Calculating date intervals Exercise 5: How long has it been?Exercise 6: Intervals between observations Exercise 7: Cleaning text data Exercise 8: Changing cases Exercise 9: Combining text data Exercise 10: Manipulating text data Exercise 11: Counting characters Exercise 12: Extracting characters Exercise 13: Substituting characters

वर्तमान अभ्यास

In this chapter, you'll learn to draw insights from your data. You'll perform complex calculations using conditional functions, logical expressions, and conditional aggregation functions. You'll also learn and apply the most important spreadsheet function: VLOOKUP!

Exercise 1: Conditional functions and logic Exercise 2: Logical expressions Exercise 3: Calculating product costs Exercise 4: Evaluting employee performance Exercise 5: Conditional aggregations Exercise 6: Analyzing expenses with conditional aggregation Exercise 7: Number of reports by person and type Exercise 8: Total expenditure by person and type Exercise 9: VLOOKUP Exercise 10: Unsorted lookups Exercise 11: Sorted lookups Exercise 12: Congratulations!