26 - Preparing Excel Headers Using Openpyxl - Part 1 - Django | DRF | React w. Data Analysis

Опубликовано: 22 Февраль 2026
на канале: Sugarloaf And a Cup of Joe
672
10

Openpyxl readthedocs page:
https://openpyxl.readthedocs.io/en/st...

About this video:
In this video we're mapping Excel file headers positions for further processing and bulk create Countries.

Video Content:
00:00 Intro
00:26 Housekeeping - make a helper semi-enumeration class foe readers
02:33 - Map headers
4:20 - Return all values from get_headers_and_units and debug
6:57 - Preparing database for pre-populating it with Countries
14:05 - Troubleshooting a broken migration
19:00 - Write bulk_create for Countries
20:46 - Create URLS for temporary country creation view
22:57 Run country creation view with and without return


About this tutorial:
The primary goal of this tutorial is to take you through the steps of creating a solid Django portfolio project that will stand out when you talk to your future employer.
Check out tutorial's intro to see if it's something for you:
   • 01 - Introduction to the course - Django -...  

Tutorial repo:
https://github.com/SugarloafAndACupOf...

Please hit SUBSCRIBE if you wanna get the notifications about the new content!
Also, like the hell out of this video if you find it useful/interesting!
Follow us on Facebook:   / sugarloaf-and-a-cup-of-joe-101638761829670  
and Instagram:   / sugarloaf_and_a_cup_of_joe