Этот материал находится в платной подписке. Оформи премиум подписку и смотри или слушай Move from Excel to Python with Pandas, а также все другие курсы, прямо сейчас!
Премиум
  1. Урок 1. 00:01:46
    Welcome!
  2. Урок 2. 00:01:29
    Challenges of Excel
  3. Урок 3. 00:01:47
    Where do Excel errors come from?
  4. Урок 4. 00:01:26
    Why Python?
  5. Урок 5. 00:01:03
    Course topics
  6. Урок 6. 00:00:10
    Get the source
  7. Урок 7. 00:00:35
    Meeting your instructor
  8. Урок 8. 00:01:01
    Python concepts you'll need
  9. Урок 9. 00:00:49
    Working on Windows
  10. Урок 10. 00:00:12
    Downloading miniconda
  11. Урок 11. 00:00:38
    Installing miniconda
  12. Урок 12. 00:00:23
    Launching miniconda
  13. Урок 13. 00:01:52
    Creating a conda environment
  14. Урок 14. 00:00:50
    Conda quick reference
  15. Урок 15. 00:00:51
    Getting organized
  16. Урок 16. 00:01:01
    Recommended file structure
  17. Урок 17. 00:00:21
    Launching Jupyter notebooks
  18. Урок 18. 00:00:43
    Auto launch Conda env with Windows terminal
  19. Урок 19. 00:01:05
    Create a project with cookiecutter
  20. Урок 20. 00:00:59
    Launching Jupyter notebooks
  21. Урок 21. 00:00:45
    Organizing within the notebook
  22. Урок 22. 00:00:49
    Data compatible with Pandas
  23. Урок 23. 00:00:40
    Where does excel fit in?
  24. Урок 24. 00:00:49
    Intro to pandas
  25. Урок 25. 00:01:13
    Pandas DataFrame vs Excel worksheets
  26. Урок 26. 00:00:47
    Understanding initial data introduction
  27. Урок 27. 00:04:13
    Demo: Understanding initial data
  28. Урок 28. 00:00:31
    Concept: Understanding your dataframe
  29. Урок 29. 00:03:14
    Working with column names
  30. Урок 30. 00:02:43
    Diving into the data
  31. Урок 31. 00:03:00
    Working with multiple columns
  32. Урок 32. 00:01:12
    Concept: Working with columns
  33. Урок 33. 00:07:47
    Working with column names
  34. Урок 34. 00:00:48
    Concept: Selecting rows and columns
  35. Урок 35. 00:02:15
    Advanced autocomplete and help
  36. Урок 36. 00:00:32
    What is data wrangling?
  37. Урок 37. 00:00:59
    Pandas data types
  38. Урок 38. 00:01:45
    Walk through of data types in Excel
  39. Урок 39. 00:03:23
    Pandas' dt, the date time accessor
  40. Урок 40. 00:04:23
    String and math manipulations
  41. Урок 41. 00:00:45
    Concept: Filtering data
  42. Урок 42. 00:04:39
    Examples of boolean filtering in pandas
  43. Урок 43. 00:03:54
    Filtering by dates
  44. Урок 44. 00:01:40
    Concept: Filtering and cleaning text and dates
  45. Урок 45. 00:01:00
    Aggregating merging grouping intro
  46. Урок 46. 00:01:05
    Examples of aggregation in excel
  47. Урок 47. 00:08:44
    Examples of aggregation in pandas
  48. Урок 48. 00:00:37
    Concept: Pandas groupby
  49. Урок 49. 00:01:34
    Concept: Pivot tables and crosstab
  50. Урок 50. 00:04:43
    Pivot table and crosstab
  51. Урок 51. 00:02:16
    Merging data in Excel
  52. Урок 52. 00:05:36
    Merging data in Pandas
  53. Урок 53. 00:00:31
    Concept: Appending data
  54. Урок 54. 00:00:30
    Intro to I/O
  55. Урок 55. 00:03:58
    Reading non-tabular Excel files
  56. Урок 56. 00:04:53
    Reading Excel and converting data types
  57. Урок 57. 00:00:41
    Reading Excel summary
  58. Урок 58. 00:02:30
    Demo: Simple Excel saves
  59. Урок 59. 00:02:07
    Demo: Multi-sheet Excel workbooks
  60. Урок 60. 00:02:26
    Demo: Complex Excel saves
  61. Урок 61. 00:00:26
    Excel writer summary
  62. Урок 62. 00:00:46
    Excel fails at reading this large file
  63. Урок 63. 00:01:57
    Pandas loves large files
  64. Урок 64. 00:00:36
    Case study introduction
  65. Урок 65. 00:00:44
    Environment setup
  66. Урок 66. 00:00:29
    Excel file intro
  67. Урок 67. 00:01:28
    Notebook setup for file reading
  68. Урок 68. 00:04:00
    Commission rate calculations
  69. Урок 69. 00:00:55
    Summary results lead to more questions
  70. Урок 70. 00:01:51
    Combining customer sales reps
  71. Урок 71. 00:02:47
    Cleaning up region
  72. Урок 72. 00:02:01
    Merging sales reps
  73. Урок 73. 00:04:33
    Cleaned, joined file
  74. Урок 74. 00:00:36
    Excel file review
  75. Урок 75. 00:00:32
    Process review
  76. Урок 76. 00:00:50
    Excel invoice files
  77. Урок 77. 00:01:38
    Excel customer invoice files
  78. Урок 78. 00:03:07
    Product commission scenarios
  79. Урок 79. 00:02:47
    Product commission variable amounts
  80. Урок 80. 00:03:19
    Commission state adjustments
  81. Урок 81. 00:02:12
    Final Excel report
  82. Урок 82. 00:01:31
    Wrapping up
  83. Урок 83. 00:01:15
    Excel challenges
  84. Урок 84. 00:00:52
    Conda review
  85. Урок 85. 00:01:29
    File structure for Jupyter
  86. Урок 86. 00:01:06
    DataFrame summary
  87. Урок 87. 00:01:26
    Data wrangling
  88. Урок 88. 00:01:34
    Grouping and joining data
  89. Урок 89. 00:00:40
    File I/O
  90. Урок 90. 00:01:17
    Practical example
  91. Урок 91. 00:01:03
    Thank you and next steps
  92. Урок 92. 00:01:26
    Concept: The shape of a program
  93. Урок 93. 00:00:51
    Concept: Variables
  94. Урок 94. 00:01:47
    Concept: Truthiness
  95. Урок 95. 00:01:25
    Concept: If else
  96. Урок 96. 00:01:32
    Concept: Complex conditionals
  97. Урок 97. 00:01:41
    Concept: for-in
  98. Урок 98. 00:01:00
    Concept: Calling functions
  99. Урок 99. 00:01:34
    Concept: Creating functions
  100. Урок 100. 00:01:20
    Concept: File I/O
  101. Урок 101. 00:02:00
    Concept: Imports and importing modules
  102. Урок 102. 00:01:54
    Concept: Python package index
  103. Урок 103. 00:02:26
    Concept: pip
  104. Урок 104. 00:03:54
    Concept: Virtual environments
  105. Урок 105. 00:02:54
    Concept: Slicing
  106. Урок 106. 00:01:44
    Concept: Tuples
  107. Урок 107. 00:01:44
    Concept: Named tuples
  108. Урок 108. 00:02:01
    Concept: Classes
  109. Урок 109. 00:01:45
    Concept: objects vs. classes
  110. Урок 110. 00:01:50
    Concept: Inheritance
  111. Урок 111. 00:00:54
    Concept: Polymorphism
  112. Урок 112. 00:02:31
    Concept: Dictionaries
  113. Урок 113. 00:02:39
    Concept: Error handling
  114. Урок 114. 00:02:09
    Concept: lambdas
  115. Урок 115. 00:02:58
    Concept: list comprehensions
  116. Урок 116. 00:00:47
    Concept: Want more foundational Python?