Indo-RNO
Indo-RNO
  • Видео 6
  • Просмотров 4 145
Python Basic for Excel/CSV File Analysis and AI Leverage
Speaker: Aldindha Octa Airlangga
Code:
github.com/aldindha/Python/blob/main/RNO.ipynb
Raw Data:
1drv.ms/f/s!Ari-fJDiX6PzkZ8gVKGtPHXm4UgC4w?e=unb0eh
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 ...
Просмотров: 355

Видео

Bongkar Rahasia Kontrak Kerja bersama R. Sosuharon W. Nababan, S.H.,CLABongkar Rahasia Kontrak Kerja bersama R. Sosuharon W. Nababan, S.H.,CLA
Bongkar Rahasia Kontrak Kerja bersama R. Sosuharon W. Nababan, S.H.,CLA
Просмотров 17118 дней назад
Speaker: R. Sosuharon W. Nababan, S.H.,CLA Host: Aldindha Octa Airlangga and Bennie Ferdiansyah Dihadiri oleh pakar hukum sebagai narasumber untuk mengupas tuntas apa-apa saja yang perlu diperhatikan ketika calon karyawan hendak menyetujui sebuah kontrak kerja. Lindungi hakmu sebelum terlambat!
SQL and Python Installation for Data AnalystSQL and Python Installation for Data Analyst
SQL and Python Installation for Data Analyst
Просмотров 25422 дня назад
Speaker: Aldindha Octa Airlangga SQL Server: www.microsoft.com/en-us/sql-server/sql-server-downloads SSMS: learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms Access Database Engine 32 Bit: www.microsoft.com/en-us/download/details.aspx?id=54920 Visual Studio Code: code.visualstudio.com/download Python Libraries/Modules: pip install pandas pip install requests pip insta...
Power BI Basic Tutorial Bahasa Indonesia - Part 2Power BI Basic Tutorial Bahasa Indonesia - Part 2
Power BI Basic Tutorial Bahasa Indonesia - Part 2
Просмотров 2413 месяца назад
Technical sharing session by Indo-RNO community Part 2 Topic: Power BI Basic Tutorial Speaker: Aldindha Octa Airlangga 1. Download and Install Power BI and Plugins: www.microsoft.com/en-us/download/details.aspx?id=58494 daxstudio.org/downloads/ www.datavizioner.com/power-bi-exporter 2. Download Link for Materials: 1drv.ms/f/s!Ari-fJDiX6PzkPtfsLbOir4zgPcxTw?e=x3fBq1 3. Download Link for Tutorial...
Power BI Basic Tutorial Bahasa Indonesia - Part 1Power BI Basic Tutorial Bahasa Indonesia - Part 1
Power BI Basic Tutorial Bahasa Indonesia - Part 1
Просмотров 8073 месяца назад
Technical sharing session by Indo-RNO community Part 1 Topic: Power BI Basic Tutorial Speaker: Aldindha Octa Airlangga 1. Download and Install Power BI and Plugins: www.microsoft.com/en-us/download/details.aspx?id=58494 daxstudio.org/downloads/ www.datavizioner.com/power-bi-exporter 2. Download Link for Materials: 1drv.ms/f/s!Ari-fJDiX6PzkPtfsLbOir4zgPcxTw?e=x3fBq1 3. Download Link for Tutorial...
QGIS Basic Tutorial Bahasa IndonesiaQGIS Basic Tutorial Bahasa Indonesia
QGIS Basic Tutorial Bahasa Indonesia
Просмотров 2,4 тыс.Год назад
1st sharing session by Indo-RNO community Topic: QGIS Basic Tutorial Speaker: Aldindha Octa Airlangga QGIS Version: 3.16.14 - Hannover Download Materials: 1drv.ms/f/s!Ari-fJDiX6PzjdtKNf54-7SDyoJYrw Download Tutorial Update: 1drv.ms/f/s!Ari-fJDiX6PzjdtLtgAu9ZPRvZO3Hw Download QGIS Version: ftp.osuosl.org/pub/osgeo/download/qgis/windows/QGIS-OSGeo4W-3.16.14-1.msi Timestamp: 00:00 Introduction 04:...

Комментарии

  • @NGERECEH
    @NGERECEH 16 часов назад

    Keren omku 🔥

  • @muhamadbayu5894
    @muhamadbayu5894 День назад

    thanks pak ilmumya

  • @ariezt3362
    @ariezt3362 2 дня назад

    Thanks om Al..semoga bermanfaat buat smua ,di lancarkan rejeki y. Amin

  • @Indo-RNO
    @Indo-RNO 2 дня назад

    Code: github.com/aldindha/Python/blob/main/RNO.ipynb Raw Data: 1drv.ms/f/s!Ari-fJDiX6PzkZ8gVKGtPHXm4UgC4w?e=unb0eh

  • @imamhidayat2857
    @imamhidayat2857 2 дня назад

    Jazakallah khiran sharingnya & semoga ilmunya makin berkah serta rejeki makin melimpah.. aamiin

  • @Indo-RNO
    @Indo-RNO 2 месяца назад

    Timestamp: 00:00 Formatting Visual 02:07 Slicer 05:03 Filter 06:04 Filter Top N 08:25 Add Title Dynamically 09:45 Add Constant Line Dynamically 16:51 Edit Interactions 21:10 Basic Mapping 23:46 Heatmap 24:53 Bubble Map 26:26 Filled Map 29:30 Custom Map with Shapefile (SHP) 35:30 Power BI and Premium Feature 36:25 Publish to Web 41:00 Get More Visuals

  • @Indo-RNO
    @Indo-RNO 2 месяца назад

    Timestamp: 00:00:00 Opening 00:02:50 Why Learn Data Analytics 00:07:03 BI Tools 00:10:00 Why Power BI 00:11:04 Disclaimer 00:12:38 Installation 00:13:10 Basic Principle 00:23:55 Get Data Excel 00:25:10 User First Row as Headers 00:26:10 Get Data CSV 00:27:00 Remove Top Rows 00:30:18 Remove Bottom Rows 00:31:46 Replace Values 00:32:33 Split Column 00:36:02 Split Column by Multi Delimiter 00:37:50 Remove Columns 00:40:28 Copying Steps 00:43:51 Get Data Excel 00:46:00 Get Data Folder 00:50:05 Get Data SQL 00:54:30 Get Data Google Sheets 00:55:50 Get Data Web 00:58:06 Fill Down 00:59:42 Enter Table Manually 01:12:50 Split Column 01:21:24 Load SQL Query as Table 01:25:07 Import vs DirectQuery 01:28:42 Change Data Source 01:29:14 Merge Columns 01:30:30 Search Column 01:31:14 Extract 01:34:12 Append Table 01:38:50 Merge Table 01:41:40 Join Table Concept 01:51:37 Conditional Column - IF THEN ELSE 01:54:27 Calculated Column - Custom Column 01:55:25 Extract Date and Time 01:58:00 Format Column Text 01:59:20 Group By 02:04:27 Pivot Column - Unpivot Column 02:10:40 Time Efficiency - Duplicate, Reference, Disable Load 02:14:46 Error Handling 02:16:56 Advanced Editor 02:19:23 Overview of Canvas, Table view, Model view 02:20:00 Insert Shape 02:22:00 Enter Table Manually 02:23:00 Add New Column 02:25:01 Join Table and RELATED/VLOOKUP 02:29:27 DAX Basic Concept 02:31:35 DAX Calculate SUM 02:38:20 DAX Calculate First Non Blank 02:45:23 DAX FILTER 02:48:14 DAX Studio 02:50:30 Add New Measure NUM DENUM 02:54:20 DAX Benchmark 02:57:40 Change Format of Column 02:58:37 DAX Calendar 02:59:23 DAX Cumulative 03:02:10 DAX Progress Tracker 03:04:46 Sorting Column for Canvas 03:05:46 Don't summarize 03:08:29 Frequent Used Visuals 03:08:36 Area Chart 03:10:45 Stacked Bar Chart 03:12:17 Treemap 03:13:45 Change Canvas Setting 03:14:17 Fit to Width 03:14:27 Line Chart 03:15:28 Change data type 03:17:34 Column Chart 03:19:10 Pie Chart 03:20:45 Scatter Chart 2D 03:23:56 Add Constant Line 03:28:12 Add Text 03:29:20 Gauge 03:30:05 KPI 03:37:42 Scatter Chart 3D 03:48:36 Matrix 03:50:26 Conditional Formatting Color 03:51:45 Ribbon Chart 03:52:10 Copy Visual 03:54:26 Formatting Visual

  • @yanuarbudi8824
    @yanuarbudi8824 2 месяца назад

    Barokallah mas sharing knowledge dan waktunya, lanjutkan mas :)

  • @ARJUNOGAMING93
    @ARJUNOGAMING93 5 месяцев назад

    Asli bagus banget ini om makasih untuk sharing ilmunya, mungkin kalau ada training online or offline saya bisa di share linknya

  • @bolatajam
    @bolatajam 11 месяцев назад

    mantap om, apakah di Qgis bisa membuat spiderline relasi neighbour om ? misal klo dimapinfo pake tools comMon

    • @Indo-RNO
      @Indo-RNO 11 месяцев назад

      Bisa cek spidergraph di tutorial pdf terbaru. Linknya ada di pinned comment.

    • @bolatajam
      @bolatajam 11 месяцев назад

      siap terimakasih banyak om@@Indo-RNO

  • @WahyuEkoPrasetyo87
    @WahyuEkoPrasetyo87 Год назад

    Appreciate Detail skali summary materinya 🙏🙏

  • @ariezt3362
    @ariezt3362 Год назад

    Terima kasih buat om" kontributor...smoga bermanfaat buat temen" smua

  • @onix4249
    @onix4249 Год назад

    makasih tutorialnya, sangat membantu

  • @vennrenn
    @vennrenn Год назад

    haturnuhun om Aldindha,, sempet lihat di awal slide ada hadist ""When a man dies, his deeds come to an end except for three things: ceaseless charity, a knowledge which is beneficial, and a pious son who prays for him (for the deceased)."" , semoga mendapatkan pahala yg terus mengalir, melalui "Ilmu yg bermanfaat" yg sudah dibagikan ini..

  • @Indo-RNO
    @Indo-RNO Год назад

    Download Link for Materials: 1drv.ms/f/s!Ari-fJDiX6PzjdtKNf54-7SDyoJYrw Download Link for Tutorial Update: 1drv.ms/f/s!Ari-fJDiX6PzjdtLtgAu9ZPRvZO3Hw

    • @suhariseputra7969
      @suhariseputra7969 Год назад

      maaf om, kok kosong ya ga ada file tutorial nya

    • @Indo-RNO
      @Indo-RNO Год назад

      @@suhariseputra7969 sign in dulu pake akun microsoft mas. Atau bisa lewat link berikut. drive.google.com/file/d/1jjHOUU85WI0GoxChul5zLV1JsZ1mwHIk/view?usp=sharing

  • @connysubangunsanggabuanatj7903

    Dangke banyak Om Al.

  • @dhanisaid6480
    @dhanisaid6480 Год назад

    Hatur nuhun pak Aldindha Octa Airlangga