Advanced Pivot Table Generator with Machine Learning Insights

Develop a Python solution that transforms raw spreadsheet data into intelligent pivot tables with embedded machine learning predictions. The script should use scikit-learn to detect patterns, create predictive columns, and generate interactive dashboards that highlight statistical anomalies. Implement automatic feature selection, handle missing data, and provide both descriptive and predictive analytics in a single comprehensive output.