Modern Data Wrangling with AI and Python Beginner to Pro

Start Download


Files Included :

1 - Welcome to the course.mp4 (13 MB)
MP4
2 - Meet Gerhard.mp4 (7.79 MB)
MP4
3 - Is this course for you.mp4 (2.05 MB)
MP4
4 - What will you get out of this course.mp4 (4.38 MB)
MP4
5 - Whats in this course.mp4 (10.27 MB)
MP4
100 - Dictionaries in action.mp4 (8.03 MB)
MP4
101 - Data types.mp4 (5.73 MB)
MP4
102 - Data types in Jupyter.mp4 (6.5 MB)
MP4
103 - Lambdas.mp4 (4.11 MB)
MP4
104 - Lambdas in action.mp4 (25.57 MB)
MP4
105 - Conclusion.mp4 (2.95 MB)
MP4
93 - Introduction.mp4 (5.14 MB)
MP4
94 - Lists.mp4 (2.54 MB)
MP4
95 - More than numbers.mp4 (6.25 MB)
MP4
96 - Lists were only scratching the surface.mp4 (2.84 MB)
MP4
97 - Lists and dictionaries in VSC.mp4 (11.53 MB)
MP4
98 - Lists in action.mp4 (13.83 MB)
MP4
99 - Dictionaries.mp4 (2.49 MB)
MP4
106 - Introduction.mp4 (5.58 MB)
MP4
107 - Example dataset A Canadian manufacturing company.mp4 (8.56 MB)
MP4
108 - A data dictionary.mp4 (7.39 MB)
MP4
109 - REFDATE changing the data type of a column.mp4 (15.75 MB)
MP4
110 - GEO getting the number of unique values in a column.mp4 (12.69 MB)
MP4
111 - Dropping a column in a dataframe.mp4 (5.76 MB)
MP4
112 - DGUID Renaming and finding the meaning of a column.mp4 (12.83 MB)
MP4
113 - Principal statistics Filtering data.mp4 (24.2 MB)
MP4
114 - Dropping mor than one column UAM and UAMID.mp4 (4.87 MB)
MP4
115 - NAICS VECTOR and COORDINATE grouping by more than one column.mp4 (20.22 MB)
MP4
116 - Status Getting the number of unique values in a column and it the dataframe.mp4 (20.52 MB)
MP4
117 - Exporting the structured transformations to a CSV file.mp4 (10.04 MB)
MP4
118 - Repeating the work weve done.mp4 (7.79 MB)
MP4
119 - The datatime data type.mp4 (9.1 MB)
MP4
120 - New methods used.mp4 (10.18 MB)
MP4
121 - Filtering.mp4 (5.55 MB)
MP4
122 - Adding a new column to a data frame.mp4 (3.09 MB)
MP4
123 - Summary.mp4 (4.96 MB)
MP4
124 - Introduction.mp4 (3.3 MB)
MP4
125 - The Netflix dataset.mp4 (12.14 MB)
MP4
126 - Converting data and extracting digits from columns.mp4 (33.32 MB)
MP4
127 - Missing rows in strings.mp4 (19.38 MB)
MP4
128 - Replacing missing values in strings.mp4 (13.38 MB)
MP4
129 - Replacing missing values in numbers.mp4 (20.02 MB)
MP4
130 - Dropping missing rows.mp4 (10.84 MB)
MP4
131 - Identifying and dropping duplicate rows.mp4 (16.52 MB)
MP4
132 - Extracting numbers out of strings.mp4 (13.53 MB)
MP4
133 - Getting parts of a string slicing and substrings.mp4 (8.14 MB)
MP4
134 - Getting the end of a string and finding help.mp4 (9.57 MB)
MP4
135 - Getting words out of a string splitting.mp4 (10.74 MB)
MP4
136 - Advanced string extraction regular expressions.mp4 (31.82 MB)
MP4
137 - Getting help with regular expressions.mp4 (8.39 MB)
MP4
138 - Applying functions to strings mapping.mp4 (17.98 MB)
MP4
139 - Summary.mp4 (3.76 MB)
MP4
140 - Introduction.mp4 (3.72 MB)
MP4
141 - Columns in dataframes series.mp4 (8.49 MB)
MP4
142 - Getting rows by their number indexes.mp4 (7.87 MB)
MP4
143 - Combining data the concat function.mp4 (16.86 MB)
MP4
144 - Adding columns together using the concat function.mp4 (4.86 MB)
MP4
145 - Combining data by the same column name merge.mp4 (16.08 MB)
MP4
146 - Understanding joins.mp4 (2.88 MB)
MP4
147 - Left join returning all the rows in the left table.mp4 (10.12 MB)
MP4
148 - Right join all the rows in the right table.mp4 (7.47 MB)
MP4
149 - Outer join all the rows in both tables.mp4 (6.01 MB)
MP4
150 - Joining tables by index the Join method.mp4 (22.9 MB)
MP4
151 - Adding a new row to the dataframe.mp4 (6.84 MB)
MP4
152 - Removing the duplicates.mp4 (3.6 MB)
MP4
153 - Adding multiple rows to a dataframe.mp4 (3.1 MB)
MP4
154 - Changing the value of existing rows update.mp4 (12.8 MB)
MP4
155 - Updating rows based on a column setting the indexes.mp4 (12.9 MB)
MP4
156 - Updating a dataframe with merge.mp4 (16.44 MB)
MP4
157 - Summary.mp4 (4.6 MB)
MP4
158 - Introduction.mp4 (4.96 MB)
MP4
159 - The characteristics of good data.mp4 (8.79 MB)
MP4
160 - Data lacking quality cause PR nightmares.mp4 (4.08 MB)
MP4
161 - Data accuracy.mp4 (13.07 MB)
MP4
162 - Getting help from GitHub copilot chat.mp4 (4.89 MB)
MP4
163 - Identifying duplicate rows reminder.mp4 (5.52 MB)
MP4
164 - Checking for missing valuesreminder.mp4 (6.72 MB)
MP4
165 - Data completeness.mp4 (5.31 MB)
MP4
166 - Data consistancy.mp4 (5.53 MB)
MP4
167 - Data reliability.mp4 (10.44 MB)
MP4
168 - Data relevance.mp4 (9.14 MB)
MP4
169 - Data timeliness.mp4 (24.96 MB)
MP4
170 - Summary.mp4 (4.6 MB)
MP4
171 - Introduction.mp4 (3.57 MB)
MP4
172 - What is data publishing.mp4 (9.01 MB)
MP4
173 - Using Faker to generate fake data.mp4 (10.16 MB)
MP4
174 - Querying the data.mp4 (19.1 MB)
MP4
175 - Getting the total and average revenue by product.mp4 (14.8 MB)
MP4
176 - Displaying revenue by product in a chart.mp4 (7.97 MB)
MP4
177 - Use Matplotlib to generate a scattered plot.mp4 (12 MB)
MP4
178 - Displaying data over time using Matplotlib and Pandas.mp4 (8.25 MB)
MP4
179 - Use Seaborn for heatmaps.mp4 (8.56 MB)
MP4
180 - Exporting results to PDF.mp4 (31.69 MB)
MP4
181 - Exporting results to Excel.mp4 (8.01 MB)
MP4
182 - Exporting to CSV.mp4 (5.96 MB)
MP4
183 - Summary.mp4 (3.97 MB)
MP4
184 - Where to from here.mp4 (6.68 MB)
MP4
185 - Congratulations.mp4 (4.8 MB)
MP4
10 - Create a Github account.mp4 (8.61 MB)
MP4
11 - GitHub Copilot chat.mp4 (8.02 MB)
MP4
12 - GitHub Copilot continued.mp4 (7.78 MB)
MP4
13 - Testing if Copilot is working.mp4 (5.63 MB)
MP4
15 - Anaconda.mp4 (5.44 MB)
MP4
16 - Installing Github Desktop.mp4 (5.21 MB)
MP4
17 - The GitHub Desktop Interface.mp4 (20.65 MB)
MP4
18 - The repository for this course.mp4 (6.14 MB)
MP4
19 - GIT optional.mp4 (7.05 MB)
MP4
20 - Summary.mp4 (2.25 MB)
MP4
6 - Introduction.mp4 (5.62 MB)
MP4
7 - Visual Studio Code Installing and getting Started.mp4 (19.57 MB)
MP4
8 - Adding Extensions to VSC.mp4 (13.4 MB)
MP4
9 - GitHub copilot.mp4 (8.22 MB)
MP4
21 - Introduction.mp4 (2.25 MB)
MP4
22 - A spreadsheet program.mp4 (21.08 MB)
MP4
23 - The challenge with spreadsheets.mp4 (42.66 MB)
MP4
24 - Follow along with me.mp4 (8.8 MB)
MP4
25 - Welcome to Python and AI.mp4 (12.95 MB)
MP4
26 - Markdown and Code fields in Jupyter.mp4 (8.4 MB)
MP4
27 - What is Pandas.mp4 (9.76 MB)
MP4
28 - Read a file in Pandas and display it.mp4 (15.28 MB)
MP4
29 - Describe the data.mp4 (12.65 MB)
MP4
30 - Do more with Copilot Jupyter and Python.mp4 (15.59 MB)
MP4
31 - Summary.mp4 (1.54 MB)
MP4
32 - Introduction.mp4 (3.58 MB)
MP4
33 - Libraries.mp4 (7.64 MB)
MP4
34 - More Pandas.mp4 (15.23 MB)
MP4
35 - Objects.mp4 (4.29 MB)
MP4
36 - Getting help from Large Language Models.mp4 (10.74 MB)
MP4
37 - Methods.mp4 (1.94 MB)
MP4
38 - Summary.mp4 (1.78 MB)
MP4
39 - My journey.mp4 (4.05 MB)
MP4
40 - Introduction.mp4 (2.74 MB)
MP4
41 - Structured Data.mp4 (12.55 MB)
MP4
42 - Structured Data in Python.mp4 (6.8 MB)
MP4
43 - CSV files as structured data.mp4 (16.45 MB)
MP4
44 - Excel data as structured data.mp4 (13.86 MB)
MP4
45 - General methods for structured data Excel and CSV.mp4 (14.07 MB)
MP4
46 - SQL Tables.mp4 (6.66 MB)
MP4
47 - SQL data in Python.mp4 (16.92 MB)
MP4
48 - Summary.mp4 (2.51 MB)
MP4
49 - Introduction.mp4 (4.42 MB)
MP4
50 - Functions.mp4 (2.82 MB)
MP4
51 - Function signatures.mp4 (5.45 MB)
MP4
52 - Function bodies.mp4 (4.99 MB)
MP4
53 - Using fucnctions.mp4 (3.23 MB)
MP4
54 - A function in action.mp4 (7.83 MB)
MP4
55 - Properties.mp4 (2.04 MB)
MP4
56 - Properties in code.mp4 (16.95 MB)
MP4
57 - For loops.mp4 (3.12 MB)
MP4
58 - For loops in code.mp4 (13.45 MB)
MP4
59 - Another example of for loops.mp4 (18.01 MB)
MP4
60 - Getting help Docstrings and signatures.mp4 (19.36 MB)
MP4
61 - Getting help online documentation.mp4 (9.77 MB)
MP4
62 - Getting help LLMs.mp4 (16.41 MB)
MP4
63 - Getting help Github copilot.mp4 (18.89 MB)
MP4
64 - Summary.mp4 (2.51 MB)
MP4
65 - Introduction.mp4 (4.15 MB)
MP4
66 - Installing Tabula in condas.mp4 (12.06 MB)
MP4
67 - Tables in PDF documents.mp4 (7.7 MB)
MP4
68 - Extracting a table from a PDF with Python.mp4 (9.54 MB)
MP4
69 - Accessing particular cells in a dataframe.mp4 (13.06 MB)
MP4
70 - Rename the columns of a dataframe.mp4 (6.13 MB)
MP4
71 - Rename columns 2 and 3 of the dataframe.mp4 (12.47 MB)
MP4
72 - Rename the remainder of the columns and concatenate strings.mp4 (4.81 MB)
MP4
73 - Delete rows from a dataframe.mp4 (7.21 MB)
MP4
74 - Split values in a column.mp4 (14.2 MB)
MP4
75 - Drop columns in a dataframe.mp4 (7.76 MB)
MP4
76 - PDFs with text.mp4 (7.11 MB)
MP4
77 - Extract text from PDFs using Python.mp4 (15.82 MB)
MP4
78 - Summary.mp4 (2.21 MB)
MP4
79 - Introduction.mp4 (2.83 MB)
MP4
80 - Web services or Application Web InterfacesAPIs.mp4 (7.84 MB)
MP4
81 - The cat facts API.mp4 (17.62 MB)
MP4
82 - HTTP response status codes.mp4 (12.76 MB)
MP4
83 - JSON payloads.mp4 (10.84 MB)
MP4
84 - More on JSON.mp4 (17.85 MB)
MP4
85 - Import API call into Postman.mp4 (12.58 MB)
MP4
86 - Making an API call in Postman.mp4 (6.49 MB)
MP4
87 - Generate code in Postman.mp4 (7.58 MB)
MP4
88 - Execute Postman code in a Jupyter Notebook.mp4 (9.36 MB)
MP4
89 - Querying JSON objects in Python.mp4 (8.26 MB)
MP4
90 - Accessing lists and nested values in JSON.mp4 (7.3 MB)
MP4
91 - Converting JSON to Dataframes.mp4 (16.46 MB)
MP4
92 - Summary.mp4 (2.4 MB)
MP4