Automate Excel Reporting Using Python (Real-Life-Example) | Pandas, Plotly, Xlwings Tutorial

Coding Is Fun โ€ข October 9, 2021
Video Thumbnail
Coding Is Fun Logo

Coding Is Fun

View Channel

About

Hi, I am Sven, a Data Analyst from Germany. ๐Ÿ‘‹ Throughout my career, I have been involved in many Data Analytics & Process Automation projects. I am passionate about finding ways to use Python and VBA to be more efficient and effective in business settings. This channel creates tutorials for people who: โ€ข ... are looking for a way to leverage the power of Python in their day-to-day work. โ€ข โ€ฆ are struggling with repetitive tasks in Excel and are looking for a way to use Python and VBA. โ€ข โ€ฆ want to learn Data Analysis & Data Science to perform meaningful and impactful analyses. โ€ข โ€ฆ are working with Excel and found themselves thinking - "there has to be a better way." If this sounds interesting to you, consider subscribing and turning on the notifications, so you donโ€™t miss any content. For more information, feel free to check out my website: https://www.pythonandvba.com Happy Coding! ๐Ÿ‘ฉโ€๐Ÿ’ป Cheers, Sven

You May Also Like

Transform Your Mornings

AI-recommended products based on this video

Loading...
MP3 Player with Bluetooth, Portable 32GB MP3 Music Players with Speaker, Supports Alarm Clock, FM Radio, Recording Function, Up to 128GB Memory Storage, Earphones Included

MP3 Player with Bluetooth, Portable 32GB MP3 Music Players with Speaker, Supports Alarm Clock, FM Radio, Recording Function, Up to 128GB Memory Storage, Earphones Included

(1)
$27.97
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
RUIZU 64GB Bluetooth MP3 Player for Kids, Cartoon Zoo Portable Music Player, Child MP3 Player with Speaker, FM Radio, Voice Recorder, Stopwatch, Pedometer, Alarm Clock, Support 128GB Micro SD Card

RUIZU 64GB Bluetooth MP3 Player for Kids, Cartoon Zoo Portable Music Player, Child MP3 Player with Speaker, FM Radio, Voice Recorder, Stopwatch, Pedometer, Alarm Clock, Support 128GB Micro SD Card

(293)
$39.59
PrimeFREE delivery Sat, Jun 14
Loading...
Bluetooth MP3 Player with 64GB TF Card, SKYBESS HiFi Lossless MP3 Music Players with HD Speaker, FM Radio, Video, Voice Recording, Alarm Clock Function, Supports Random Playback, Earphones Included

Bluetooth MP3 Player with 64GB TF Card, SKYBESS HiFi Lossless MP3 Music Players with HD Speaker, FM Radio, Video, Voice Recording, Alarm Clock Function, Supports Random Playback, Earphones Included

(16)
$27.99
FREE delivery Sat, Jun 14 on your first order
Loading...
zicor Kids Smart Watch Gift with Dual Camera, Puzzle Games, Pedometer, Music Player, Video Recorder, Parental Control, Alarm Clock, HD Touch Screen, Toy Smart Watch for Boys and Girls Age 4-12 (Pink)
Best Seller

zicor Kids Smart Watch Gift with Dual Camera, Puzzle Games, Pedometer, Music Player, Video Recorder, Parental Control, Alarm Clock, HD Touch Screen, Toy Smart Watch for Boys and Girls Age 4-12 (Pink)

(286)
$49.99
PrimeFREE delivery Sat, Jun 14
200+ bought in past month
Loading...
Infiniti PRO by CONAIR Steam Therapy Hair Steamer, Portable Hair Steamer with 7" Diffuser Attachment, 30-Second Heat Up, Penetrating Steam Helps Detangle, Reshape, and Volumize Curls

Infiniti PRO by CONAIR Steam Therapy Hair Steamer, Portable Hair Steamer with 7" Diffuser Attachment, 30-Second Heat Up, Penetrating Steam Helps Detangle, Reshape, and Volumize Curls

(16)
$83.91
FREE delivery Thu, Sep 11
50+ bought in past month
Loading...
iDOO WiFi 12 Pods Hydroponic Growing System with 6.5L Water Tank, Smart Hydro Indoor Herb Garden Up to 14.5", Plants Germination Kit with Pump System, Fan, Grow Light for Home Kitchen Gardening, Black

iDOO WiFi 12 Pods Hydroponic Growing System with 6.5L Water Tank, Smart Hydro Indoor Herb Garden Up to 14.5", Plants Germination Kit with Pump System, Fan, Grow Light for Home Kitchen Gardening, Black

(585)
$179.99
PrimeFREE delivery Sat, Jun 14
Loading...
CORSAIR Hydro X Series iCUE Link XH405i Custom Cooling Kit โ€“ Hardline Water Cooling Loop โ€“ XC7 Elite CPU Water Block โ€“ XD5 Elite D5 Pump Res โ€“ XR5 360mm Radiator โ€“ 3X QX120 RGB Fans

CORSAIR Hydro X Series iCUE Link XH405i Custom Cooling Kit โ€“ Hardline Water Cooling Loop โ€“ XC7 Elite CPU Water Block โ€“ XD5 Elite D5 Pump Res โ€“ XR5 360mm Radiator โ€“ 3X QX120 RGB Fans

(235)
$879.99
FREE delivery Sun, Aug 24
Loading...
Monster N-Lite 211 Wireless Earbuds๏ผŒ Bluetooth 6.0 Stereo Headphones with Noise-Cancelling Mic and LED Display, Built-in Mic for Clear Calls, Waterproof Design for Sports

Monster N-Lite 211 Wireless Earbuds๏ผŒ Bluetooth 6.0 Stereo Headphones with Noise-Cancelling Mic and LED Display, Built-in Mic for Clear Calls, Waterproof Design for Sports

(8)
$39.99
FREE delivery Tue, Nov 4
Loading...
Monster N-Lite 211 Wireless Earbuds, Bluetooth 6.0 Stereo Headphones with Powerful Bass, Built-in Noise-Cancelling Mic for Clear Calls, LED Display, 36H Playtime, IPX5 Waterproof Design for Sports

Monster N-Lite 211 Wireless Earbuds, Bluetooth 6.0 Stereo Headphones with Powerful Bass, Built-in Noise-Cancelling Mic for Clear Calls, LED Display, 36H Playtime, IPX5 Waterproof Design for Sports

(40)
$39.99
FREE delivery Thu, Nov 13
Loading...
Shower Steamers Aromatherapy 8 Pack Gifts for Women & Men Bath Bombs, Organic Eucalyptus & Menthol Essential Oil,Birthday Gifts for Wife & Husband Spa Relaxing, Travel Essentials Aromatherapy

Shower Steamers Aromatherapy 8 Pack Gifts for Women & Men Bath Bombs, Organic Eucalyptus & Menthol Essential Oil,Birthday Gifts for Wife & Husband Spa Relaxing, Travel Essentials Aromatherapy

(54)
$13.99
FREE delivery Thu, Sep 11 on your first order
100+ bought in past month
Loading...
LED Desk Lamp with Dual Heads, Height Adjustable, USB Charging Port, 5 Light Modes & Dimmable Brightness, Bedside Lamp for Reading, Crafting, Work, Study (White, 15W)

LED Desk Lamp with Dual Heads, Height Adjustable, USB Charging Port, 5 Light Modes & Dimmable Brightness, Bedside Lamp for Reading, Crafting, Work, Study (White, 15W)

(3,090)
$20.99
FREE delivery Sat, Jun 14 on your first order
Loading...
Figure 8 Fitness Resistance Band 3 Pcs, Elastic Rope Stretch Bands for Working Out, Foot, Leg, Arm, Back, Chest, Portable Home Office Training Exercise Stretcher for Yoga Pilates Physical Therapy

Figure 8 Fitness Resistance Band 3 Pcs, Elastic Rope Stretch Bands for Working Out, Foot, Leg, Arm, Back, Chest, Portable Home Office Training Exercise Stretcher for Yoga Pilates Physical Therapy

(2)
$15.99$8.90
FREE delivery Sun, Aug 10 on your first order
Loading...
Yes4All Aerobic Stepper Exercise Steps with Adjustable Height, Fitness Stepper for Home & Gym, Aerobics, Cardio, Weights, Yoga

Yes4All Aerobic Stepper Exercise Steps with Adjustable Height, Fitness Stepper for Home & Gym, Aerobics, Cardio, Weights, Yoga

(8,956)
$130.20$81.85
FREE delivery Sat, Jun 28
Loading...
Amicus Mini Stepper with Handlebar for Exercise, Stair Stepper with Resistance Band, Hydraulic Fitness Stepper Machine for Home, 330lbs Weight Capacity

Amicus Mini Stepper with Handlebar for Exercise, Stair Stepper with Resistance Band, Hydraulic Fitness Stepper Machine for Home, 330lbs Weight Capacity

(115)
$119.18
FREE delivery Sat, Jun 28
Loading...
Ucootifly Aerobic Exercise Step Adjustable Aerobic Stepper for Exercise Workout Step Platform for Step Up, 27" Step Deck with 4โ€ 6โ€ 8โ€ Adjustable Height Risers, Women Home Gym Cardio Fitness

Ucootifly Aerobic Exercise Step Adjustable Aerobic Stepper for Exercise Workout Step Platform for Step Up, 27" Step Deck with 4โ€ 6โ€ 8โ€ Adjustable Height Risers, Women Home Gym Cardio Fitness

(6)
$58.99
FREE delivery Sat, Jun 28
Loading...
ASUS ZenScreen 15.6โ€ 1080P Portable Monitor (MB16ACVR) - Full HD, IPS, Eye Care, Flicker Free, Blue Light Filter, Kickstand, USB-C Power Delivery, for Laptop, PC, Phone, Console, Antibacterial Surface

ASUS ZenScreen 15.6โ€ 1080P Portable Monitor (MB16ACVR) - Full HD, IPS, Eye Care, Flicker Free, Blue Light Filter, Kickstand, USB-C Power Delivery, for Laptop, PC, Phone, Console, Antibacterial Surface

(2,000)
$209.00
FREE delivery Aug 11 - 13
Loading...
Desnuage Teardrop Aquamarine Hoop Earrings Sterling Silver Dangle Light Blue Earrings for Women

Desnuage Teardrop Aquamarine Hoop Earrings Sterling Silver Dangle Light Blue Earrings for Women

(1)
$19.99
FREE delivery Sun, Jul 6 on your first order
Loading...
Watforsh Big Blue Leaf Silver Dangle Earrings for Women Boho Earrings Drop with Light Blue and Beige Bohemian Tropical Style Plant Dangling for Gift

Watforsh Big Blue Leaf Silver Dangle Earrings for Women Boho Earrings Drop with Light Blue and Beige Bohemian Tropical Style Plant Dangling for Gift

(1)
$20.99
FREE delivery Sun, Jul 6 on your first order
Loading...
IPROKKO Laptop 14 inch Privacy Screen Filter for Hp/Dell/Thinkpad/Lenovo/Samsung/Asus/Sony, 16:9 Aspect Ratio Removable Anti Blue Light Glare Protector, 14 in Privacy Shield

IPROKKO Laptop 14 inch Privacy Screen Filter for Hp/Dell/Thinkpad/Lenovo/Samsung/Asus/Sony, 16:9 Aspect Ratio Removable Anti Blue Light Glare Protector, 14 in Privacy Shield

(137)
$31.99
FREE delivery Tue, Jun 17 on your first order
Loading...
FITVII Health & Fitness Tracker (Answer/Make Calls), Smart Watch with 24/7 Heart Rate and Blood Pressure, Sleep Tracking Monitor, 120+ Sport Mode Activity Tracker

FITVII Health & Fitness Tracker (Answer/Make Calls), Smart Watch with 24/7 Heart Rate and Blood Pressure, Sleep Tracking Monitor, 120+ Sport Mode Activity Tracker

(198)
$59.99
FREE delivery Sun, Aug 10
100+ bought in past month
Loading...
AYATAHA AYATAHA Smart Watch for Kids, Smartwatch Fitness Tracker for Boys Girls, Children's Activity Watch 37 Sports Modes SMS Notification, HD Full Touchscreen IP67 Waterproof, Blue

AYATAHA AYATAHA Smart Watch for Kids, Smartwatch Fitness Tracker for Boys Girls, Children's Activity Watch 37 Sports Modes SMS Notification, HD Full Touchscreen IP67 Waterproof, Blue

(55)
$41.99
PrimeFREE delivery Sat, Jun 14
Loading...
Iaret Iaret Smart Watch for Women, 1.83" HD Fitness Tracker with 4 Bands, Answer/Make Calls, Heart Rate/Sleep/SpO2/Step Tracking, 100+ Sport Modes, Android/iPhone Compatible Gift (Rose Gold)

Iaret Iaret Smart Watch for Women, 1.83" HD Fitness Tracker with 4 Bands, Answer/Make Calls, Heart Rate/Sleep/SpO2/Step Tracking, 100+ Sport Modes, Android/iPhone Compatible Gift (Rose Gold)

(42)
$59.99
FREE delivery Thu, Jun 19
100+ bought in past month
Loading...
Smart Watch for Men Women 1.8" Fitness Tracker, Bluetooth Call, DIY Dial, Heart Rate Sleep Blood Oxygen Monitor, 100+ Sports Modes, IP68 Waterproof Smartwatch for Android iPhone, Alexa Built-in

Smart Watch for Men Women 1.8" Fitness Tracker, Bluetooth Call, DIY Dial, Heart Rate Sleep Blood Oxygen Monitor, 100+ Sports Modes, IP68 Waterproof Smartwatch for Android iPhone, Alexa Built-in

(980)
$39.99
FREE delivery Sun, Sep 21
300+ bought in past month