perbandingan Excel vs SQL vs Python dalam analisis berbagai tugas
tabel perbandingan Excel vs SQL vs Python dalam menyelesaikan berbagai tugas analisis data umum: 📊 Perbandingan Excel vs SQL vs Python Task Excel SQL Python (pandas) 1. Filter rows Filter/Slicer, IF , FILTER() WHERE clause df[df['col'] == value] 2. Select columns Klik kolom / pilih secara manual SELECT column1, column2 df[['col1', 'col2']] 3. Sort data Sort tool (ascending/descending) ORDER BY column ASC/DESC df.sort_values('col', ascending=True) 4. Grouping Pivot Table / SUBTOTAL() GROUP BY column df.groupby('col') 5. Counting COUNT() , Pivot Table COUNT(column) df['col'].count() or df.groupby(...).count() 6. Average AVERAGE() , Pivot Table AVG(column) df['col'].mean() 7. Sum SUM() SUM(column) df['col'].sum() 8. Remove duplicates "Remove Duplicates" tool SELECT DISTINCT df.drop_duplicates() 9. Join tables VLOOKUP / XLOOKUP / Power Query JOIN , L...