零售智慧之Power BI大數據分析-02.如何做數據清理?

<div data-block="true" data-editor="9d8r2" data-offset-key="8f45b-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> 零售智慧之Power BI大數據分析-02.如何做數據清理?

2-1.編號、學號等文字類型數據清理20220511-0

2-2.日期類型數據清理如:民國日期轉成西元日期0

2-3.百分比與小數只到小數位1位

<div data-block="true" data-editor="9d8r2" data-offset-key="tr48-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> https://youtu.be/utsKaD3zCls

<div data-block="true" data-editor="9d8r2" data-offset-key="eiv34-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> 範例與講義下載: https://goo.gl/ytzRxT

<div data-block="true" data-editor="9d8r2" data-offset-key="hiva-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> 如果影片對你有幫助，記得訂閱並加入【孫在陽】頻道

<div data-block="true" data-editor="9d8r2" data-offset-key="f7pko-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> https://www.youtube.com/c/KemSun/fe ...

<div data-block="true" data-editor="9d8r2" data-offset-key="95p0c-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> #零基礎學電腦 #OFFICE #電腦教學 #免費學習 #大數據分析 #GOOGLE #VBA自動

<div data-block="true" data-editor="9d8r2" data-offset-key="6ildo-0-0" style="font-family: "Segoe UI Historic", "Segoe UI", Helvetica, Arial, sans-serif; color: rgb(5, 5, 5); font-size: 15px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: pre-wrap; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"> 蝦皮賣場: https://shopee.tw/a0829kimo

零基礎學電腦

介紹分享資訊安全及office 各項使用技巧／免費電腦教學

零售智慧之Power BI大數據分析-02.如何做數據清理?

個人資訊

熱門文章

文章分類

最新文章

動態訂閱

文章精選

文章搜尋

參觀人氣