Kontinuierliche fehlende Werte auffüllen

In der letzten Lektion hast du verschiedene Methoden kennengelernt, um fehlende Werte zu entfernen und fehlende Werte mit einem festen String zu füllen. Diese Ansätze sind in vielen Fällen sinnvoll, besonders bei kategorialen Spalten, haben aber nur begrenzten Nutzen bei kontinuierlichen Werten. In solchen Fällen ist es oft am sinnvollsten, die fehlenden Werte in der Spalte mit einem aus den vorhandenen Einträgen der Spalte berechneten Wert zu füllen.

Diese Übung ist Teil des Kurses

<Kurs>Feature Engineering für Machine Learning in Python</Kurs>

Interaktive praktische Übung

Versuche dich an dieser Übung, indem du diesen Beispielcode vervollständigst.

# Print the first five rows of StackOverflowJobsRecommend column
print(____)

Code bearbeiten und ausführen

Diese Übung ist Teil des Kurses

<Kurs>Feature Engineering für Machine Learning in Python</Kurs>

Mittlere SchwierigkeitSchwierigkeitsgrad

4.8+

Kurs kostenlos starten

In this chapter, you will explore what feature engineering is and how to get started with applying it to real-world data. You will load, explore and visualize a survey response dataset, and in doing so you will learn about its underlying data types and why they have an influence on how you should engineer your features. Using the pandas package you will create new features from both categorical and continuous columns.

Exercise 1: Why generate features?Exercise 2: Getting to know your data Exercise 3: Selecting specific data types Exercise 4: Dealing with categorical features Exercise 5: One-hot encoding and dummy variables Exercise 6: Dealing with uncommon categories Exercise 7: Numeric variables Exercise 8: Binarizing columns Exercise 9: Binning values

This chapter introduces you to the reality of messy and incomplete data. You will learn how to find where your data has missing values and explore multiple approaches on how to deal with them. You will also use string manipulation techniques to deal with unwanted characters in your dataset.

Exercise 1: Warum gibt es fehlende Werte?Exercise 2: Wie lückenhaft sind meine Daten?Exercise 3: Fehlende Werte finden Exercise 4: Umgang mit fehlenden Werten (I)Exercise 5: Listweises Löschen Exercise 6: Fehlende Werte durch Konstanten ersetzen Exercise 7: Umgang mit fehlenden Werten (II)Exercise 8: Kontinuierliche fehlende Werte auffüllen

Aktuelle Übung

Exercise 9: Werte in prädiktiven Modellen imputieren Exercise 10: Mit weiteren Datenproblemen umgehen Exercise 11: Umgang mit unerwünschten Zeichen (I)Exercise 12: Umgang mit Fremdzeichen (II)Exercise 13: Method Chaining

In this chapter, you will focus on analyzing the underlying distribution of your data and whether it will impact your machine learning pipeline. You will learn how to deal with skewed data and situations where outliers may be negatively impacting your analysis.

Exercise 1: Data distributions Exercise 2: What does your data look like? (I)Exercise 3: What does your data look like? (II)Exercise 4: When don't you have to transform your data?Exercise 5: Scaling and transformations Exercise 6: Normalization Exercise 7: Standardization Exercise 8: Log transformation Exercise 9: When can you use normalization?Exercise 10: Removing outliers Exercise 11: Percentage based outlier removal Exercise 12: Statistical outlier removal Exercise 13: Scaling and transforming new data Exercise 14: Train and testing transformations (I)Exercise 15: Train and testing transformations (II)

Finally, in this chapter, you will work with unstructured text data, understanding ways in which you can engineer columnar features out of a text corpus. You will compare how different approaches may impact how much context is being extracted from a text, and how to balance the need for context, without too many features being created.

Exercise 1: Encoding text Exercise 2: Cleaning up your text Exercise 3: High level text features Exercise 4: Word counts Exercise 5: Counting words (I)Exercise 6: Counting words (II)Exercise 7: Limiting your features Exercise 8: Text to DataFrame Exercise 9: Term frequency-inverse document frequency Exercise 10: Tf-idf Exercise 11: Inspecting Tf-idf values Exercise 12: Transforming unseen data Exercise 13: N-grams Exercise 14: Using longer n-grams Exercise 15: Finding the most common words Exercise 16: Wrap-up