1001 Freelance Projects
Latest Projects from
Freelance Marketplaces
View Project
View this project in detail
(Note: you will be redirected to external marketplace)
Project title:
Exploratory data analysis & regression model in python by 20/08
Posted by:
External project from PeoplePerHour
Started:
16-Aug-2025 13:05 GMT
Description:
Part1 : Provided a dataset of volume sales of products from 2019 to 2022 run an extensive exploratory data analysis including the following: .
1. Data Quality & Structure Checks
Missing values, duplicates, negative sales, outliers
Date consistency (no gaps, proper frequency, handling holidays/weekends)
2. Descriptive Statistics
Overall distribution of daily sales (mean, median, std, skewness, kurtosis)
By dimension: product, customer
Identify top products per customer by volume
3. Time Series Exploration
Trend: long-term upward or downward movement
Seasonality: daily/weekly patterns (weekdays vs weekends), monthly, quarterly, yearly cycles
Rolling averages (7-day, 30-day) to smooth patterns
4. Visualization Layer
Time series plots: raw daily sales, moving averages
Boxplots: distribution of sales by weekday or month
Histograms/density plots: sales distribution
5. Anomaly & Outlier Detection
Unusual spikes/drops
Use Z-scores or interquartile ranges to flag anomalies
6. Correlation & Drivers of Sales
Correlation if needed
7. Performance Metrics (Baseline)
Set benchmarks to prepare for forecasting models:
Average daily sales per SKU/store
Volatility (Coefficient of Variation)
Baseline forecast error (e.g., naïve forecast MAPE)

EDA Deliverables :
By the end of an extensive EDA, I should have:
Clear understanding of demand patterns, seasonality, and anomalies
Insights into drivers of sales (internal like price/promo, external like weather/events)
Segmentation of products into high/medium/low performers
A baseline performance snapshot to compare forecasting models against.


Part 2 :
After cleaning the data based on the above analysis, run a linear regression-based model to prepare a sales volume forecast at product & customer level for 2022 in python or/and pyspark. Measure the accuracy by introducing quality measures and explain why have you introduced these measures.
Project ID:
3445343
Project category:
Project budget:
View this project in detail
(Note: you will be redirected to external marketplace)
Last Projects / Browse Projects
  Project Started
Instagram Influencers for Spotify Streams
Category: Analytics, Content Creation, Content Strategy, Creative Writing, Digital Marketing, Influencer Marketing, Instagram Marketing, Social Media Marketing
Budget: $30 - $250 USD
19 Dec 2025 17:04 GMT
JD: PCB Designer (Wearable) – Hardware
Category: Automation, Circuit Design, Debugging, Documentation, Electrical Engineering, Electronic Forms, Electronics, Firmware, PCB Layout, Scripting
Budget: $15 - $25 USD
19 Dec 2025 17:04 GMT
Realistic Outdoor Sculptures
Category: 3D Art, 3D Graphic Design, 3D Illustration, 3D Rendering, Art Installation, Graphic Design, Interior Design, Mural Painting, Sculpture, Visual Arts
Budget: $750 - $1500 USD
19 Dec 2025 17:03 GMT
Cross-Platform Flutter App Development
Category: Android, API Integration, Dart, Flutter, HTML5, IOS Development, IPhone, Mobile App Development
Budget: $10 - $30 USD
19 Dec 2025 17:03 GMT
Modern Metal Handrail Shop Drawings
Category: 2D Drafting, 3D Modelling, Architectural Engineering, AutoCAD, Building Architecture, Building Design, CAD / CAM, Construction Engineering
Budget: £20 - £250 GBP
19 Dec 2025 17:02 GMT
Operational Power BI Dashboard Design
Category: Data Visualization, Power BI
Budget: ₹100 - ₹400 INR
19 Dec 2025 17:01 GMT
Edit Educational Story Video
Category: Adobe Premiere Pro, After Effects, Audio Editing, DaVinci Resolve, Motion Graphics, Video Editing, Video Production, Video Services
Budget: ₹600 - ₹1500 INR
19 Dec 2025 17:01 GMT
WordPress Elementor Website Management
Category: Elementor, HTML, PHP, Web Development, Web Hosting, Web Design, Website Management, WordPress
Budget: $15 - $25 USD
19 Dec 2025 17:00 GMT
Telegram Lecture Downloader Android
Category: Android, Android Studio, API Integration, App Design, Java, Mobile App Development, Mobile Development, Software Architecture, Software Development, Telegram API
Budget: ₹1500 - ₹12500 INR
19 Dec 2025 17:00 GMT
Credit Report Inaccuracy Disputes
Category: Accounting, Audit, Compliance, Credit Analysis, Credit Repair, Finance, Intuit QuickBooks, Legal Consultation
Budget: $10 - $15 USD
19 Dec 2025 16:57 GMT
Academic Rewrite: Research Paper (1200) words in 2 days
Category: Academic Research, Academic Writing, Article Rewriting, Content Writing, Editing, Proofreading, Research, Research Writing, Technical Writing
Budget: $10 - $30 USD
19 Dec 2025 16:56 GMT
Bangalore Housing Data Manipulation
Category: Data Analysis, Data Extraction, Data Management, Data Science, Data Visualization, NumPy, Pandas, Python
Budget: ₹400 - ₹750 INR
19 Dec 2025 16:56 GMT
New York Dental Clinic Leads
Category: B2B Marketing, Data Collection, Data Entry, Data Scraping, Database Management, Excel, Lead Generation, Web Scraping, Web Search
Budget: ₹12500 - ₹37500 INR
19 Dec 2025 16:56 GMT
Worldwide Amazon Book Launch
Category: Amazon, Amazon Kindle, Book Cover Design, Book Marketing, Digital Marketing, Market Research, Publishing, SEO
Budget: $250 - $750 USD
19 Dec 2025 16:55 GMT
WordPress Promo Banner & Multilingual Upgrade
Category: Graphic Design, HTML, PHP, SEO, Web Design, Web Development, WordPress, WordPress Plugin
Budget: $30 - $250 USD
19 Dec 2025 16:53 GMT
Browse All Projects
Projects by Skills ...
android
ajax
asp
aspnet
cms
cpp
csharp
css
delphi
design
drupal
excel
facebook
flash
html
java
javascript
joomla
iphone
mysql
photoshop
php
python
ruby
seo
sql
sysadm
translate
typing
twitter
vbnet
xml
wordpress
writing
New!
Проекты на русском
(Projects in Russian)

Copyright © 2005-2024
1001 Freelance Projects