Speaker: Aldindha Octa Airlangga

Code:
https://github.com/aldindha/Python/bl...

Raw Data:
https://1drv.ms/f/s!Ari-fJDiX6PzkZ8gV...

Timestamp:
00:00:00 Create Python File
00:00:39 Import Pandas
00:02:22 Import Excel File
00:04:41 Add Comment
00:05:35 Remove Duplicates
00:07:10 See top 50 rows
00:08:08 Set Maximum Display of Rows
00:09:08 Observe Columns
00:12:27 Check Distinct Value of a Column
00:15:34 Rename Columns
00:17:50 Filter Table by Columns Value
00:25:32 Delete Rows
00:28:28 Delete Columns
00:30:28 Export to CSV
00:32:20 Export to Excel
00:33:10 Export to Clipboard
00:34:56 Import CSV File
00:37:32 Set Maximum Display of Columns
00:38:20 Replace Values
00:40:53 Add Calculated Column of Number
00:43:27 Add Concatenate Column of Text
00:44:55 Move Column
00:47:24 Setting CSV Dataframe
00:50:53 AI Leverage by ChatGPT part 1
00:52:46 Append Dataframes
00:53:41 Choose Columns / Remove Other Columns
00:55:53 AI Leverage by ChatGPT part 2
00:56:54 Append Dataframes Automatically on a Folder