Data hilang tingkat lanjut

Pada latihan sebelumnya, Anda melihat cara mengidentifikasi berapa banyak nilai hilang di setiap kolom DataFrame, lalu Anda dapat langsung menghapus baris yang memiliki nilai hilang. Namun, bagaimana jika ada banyak baris dengan nilai hilang? Bagaimana jika Anda tidak ingin begitu saja mulai menghapus baris dari data? Di sinilah konsep penggantian (replacement) digunakan — Anda dapat mengganti nilai hilang dengan nilai lain.

Dalam latihan ini, Anda akan bekerja dengan DataFrame sales_df yang sama seperti pada latihan sebelumnya, tetapi alih-alih menghapus nilai hilang, Anda akan menggantinya di setiap kolom dengan rata-rata dari semua nilai yang tidak hilang. Anda akan menulis sebuah fungsi yang kemudian dapat diterapkan pada kolom mana pun dalam sebuah DataFrame.

Latihan ini adalah bagian dari kursus

Julia Tingkat Menengah

Latihan interaktif praktis

Cobalah latihan ini dengan menyelesaikan kode contoh berikut.

# Define a function replace_missing that takes one argument, the name of the column we want to modify
____ replace_missing(____)
end

Edit dan Jalankan Kode

Latihan ini adalah bagian dari kursus

Julia Tingkat Menengah

SkillTag.level.beginnerSkillTag.label

4.7+

Mulai Kursus Gratis

Loops are one of the core concepts that underpin Julia. In this chapter, you'll learn about for loops and while loops, and how to use them to iterate over data structures that you are already familiar with. You will also cover ranges, a useful tool for generating sequences of data.

Exercise 1: For loops Exercise 2: For loops question Exercise 3: Loop over a vector Exercise 4: Loops and enumerate Exercise 5: Looping over nested structures Exercise 6: While loops Exercise 7: Writing a while loop Exercise 8: While loops for iteration Exercise 9: Ranges Exercise 10: Ranges - iteration Exercise 11: Defining ranges Exercise 12: Looping over ranges Exercise 13: Splat unpacking

This chapter focuses on expanding your knowledge of the data structures available in Julia. Learn how to use tuples, dictionaries, multi-dimensional arrays, and structures to store and traverse data quickly and efficiently.

Exercise 1: Tuples Exercise 2: When should you use a tuple?Exercise 3: Create, index, and slice a tuple Exercise 4: Create a NamedTuple for a person Exercise 5: Dictionaries Exercise 6: Create untyped dict, iterate Exercise 7: Create typed dict, iterate Exercise 8: Modify keys/values in dict, use get()Exercise 9: Multi-dimensional arrays Exercise 10: Create 1D and 2D arrays Exercise 11: Index and slice a 2D array Exercise 12: Array merging Exercise 13: Structs Exercise 14: Define a structure Exercise 15: Mutable and typed structs

In this chapter, you’ll extend your understanding of functions, exploring positional, keyword, and default function arguments. You will also cover code execution timing, getting a strong understanding of how to measure the time your code takes to run. This chapter will round off with a capstone on writing your own functions to solve real-world problems.

Exercise 1: Execution time and measurement Exercise 2: Built-in time macro Exercise 3: Timing a function Exercise 4: Positional and Default Arguments, Type Declarations Exercise 5: Positional arguments recap Exercise 6: Default arguments Exercise 7: Type declarations Exercise 8: Keyword Arguments Exercise 9: Keyword arguments Exercise 10: Variable number of arguments Exercise 11: Writing Your Own Function Exercise 12: Writing your own functions Exercise 13: Writing your own functions - structs

This final chapter will introduce anonymous functions and will recap one of the powerful features of Julia; multiple dispatch. You will learn how to use functions from Python and R packages within Julia and discover how to clean and modify data within dataframes.

Exercise 1: Fungsi Anonim dan Multiple Dispatch Exercise 2: Multiple dispatch Exercise 3: Fungsi anonim Exercise 4: Menyaring DataFrame Exercise 5: Mengimpor Fungsi dari Python dan R Exercise 6: Mengimpor Python dan R Exercise 7: Fungsi Python di Julia Exercise 8: Fungsi R di Julia Exercise 9: Membersihkan Data Exercise 10: Mengganti nama kolom Exercise 11: Data hilang Exercise 12: Data hilang tingkat lanjut

Latihan Saat Ini

Exercise 13: Selamat!