2025年7月21日
PowerBI, 以日期排序后, 再以某列去重,
摘要： Table = VAR TempTable = ADDCOLUMNS( 'Sheet1', "Rank", RANKX( FILTER('Sheet1', 'Sheet1'[id] = EARLIER('Sheet1'[id])), 'Sheet1'[date], , DESC, Dense ) ) 阅读全文
posted @ 2025-07-21 16:09 CrossPython 阅读(25) 评论(0) 推荐(0)
SQL异常字符去除
摘要： import pandas as pd from grant.sql_connection import tellus_conn sql = r'''select a.uid,REGEXP_REPLACE(a.beizhu, '[\\x00-\\x1F\\x7F]', '') AS beizhu_c 阅读全文
posted @ 2025-07-21 15:21 CrossPython 阅读(10) 评论(0) 推荐(0)