Python v Exceli
5h 12min
Time
32
Chapters
Programovanie
Category
5.0
Rating
Intermediate
Level
czech
Language
Chapters
Prostředí Python v Excelu
1. Obsah a nastavení Pythonu
5min
Available only with full access purchase
2. Prostředí Pythonu v Excelu
8min
Available only with full access purchase
3. Tvorba prvního Python kódu
5min
Available only with full access purchase
4. Práce s oblastmi
4min
Available only with full access purchase
5. Excel Labs
3min
Available only with full access purchase
6. Knihovny v Pythonu
8min
Available only with full access purchase
7. Výhody a nevýhody Pythonu v Excelu
5min
Available only with full access purchase
Základní práce s daty
8. Zakladní operace s DataFrame
11min
Available only with full access purchase
9. Indexace
6min
Available only with full access purchase
10. Filtrování
8min
Available only with full access purchase
11. Řazení
8min
Available only with full access purchase
Čištění & Úprava dat
12. Přidávání, odstraňování a úprava sloupců a řádků
9min
Available only with full access purchase
13. Chybějící data a duplicity
10min
Available only with full access purchase
14. Datové typy
5min
Available only with full access purchase
15. Manipulace textu
13min
Available only with full access purchase
16. F-Strings
6min
Available only with full access purchase
Základní analýza dat
17. Podminková logika
8min
Available only with full access purchase
18. Cykly
8min
Available only with full access purchase
19. Skupinová analýza a agregace textových sloupců
8min
Available only with full access purchase
20. Seskupení časové řady
11min
Available only with full access purchase
21. Připojení dat
7min
Available only with full access purchase
22. Sloučení dat
9min
Available only with full access purchase
Pokročilá analýza dat
23. Rolling sum
6min
Available only with full access purchase
24. Kontingenční tabulky
10min
Available only with full access purchase
25. Výpočty v DataFrame (Apply/Map)
13min
Available only with full access purchase
26. Regulární výrazy
9min
Available only with full access purchase
Vizualizace dat
27. Základní grafy
13min
Available only with full access purchase
28. Pokročilé grafy
11min
Available only with full access purchase
29. Úprava grafu
13min
Available only with full access purchase
Pokročilé kombinované nástroje
30. Kombinace PowerQuery (s SQL) a Python v Excelu
11min
Available only with full access purchase
31. VBA a Python v Excelu
16min
Available only with full access purchase
Praktický příklad
32. Komplexní příklad
30min
Available only with full access purchase
12
Online courses
8
Posts