Using docxtpl to create word/docx files based on a template docx file. Python then creates new word/docx files, inserting data, where there is a match between the template and the CSV. One Docx per row in the CSV. I show an example with 6 rows in the CSV, making 6 Docx files, each file has unique content from the CSV. After a request from a subscriber, I have now added the code to make the filenames based upon values form the CSV. Modify the numerical filenames system from 1,2,3,4 etc... enumerated sequence to values from 'title' column. ⚪ My subscriber actually sent me the solution before I had chance to work on this, so credit due to suhas g for the following solution: ✅ Using pandas dataframe, df.loc, it is fairly trivial, just select the row/column with [:, 'title'] This is something I didn't add initially as there was a requirement to manually rename the files once I had raised a change reference in another laborious system! I hope this is useful? Credit : Eric Lapouyade https://docxtpl.readthedocs.io/en/latest/ #docxtpl All my GitHub Code : ⚪ https://github.com/RGGH/pydoc CSV Specific code : ⚪ https://github.com/RGGH/pydoc/tree/master/conditional ☕️☕️☕️ Buy Dr Pi a Coffee...or Tea! : https://www.buymeacoffee.com/DrPi ☕️☕️☕️ ... https://www.youtube.com/watch?v=F71BplyOaWQ

Network Automation using Python and Jinja. Jinja templates are a fast, repeatable way to render documents based on your own original template. The code in this example shows you how to create Cisco router configs from a script reading values from a CSV file. "Jinja is a fast, expressive, extensible templating engine. Special placeholders in the template allow writing code similar to Python syntax." ? https://pypi.org/project/Jinja2/ = Chapter timings = ------------------------------------ ⭕ 0:00 Intro ⭕ 4:34 Code ⭕ 7:20 Read values from CSV ⭕ 15:04 Test the code ⭕ 18:00 Output to text file ----------------------------------------------- Network Automation Playlist: ? https://www.youtube.com/playlist?list=PLKMY3XNPiQ7vhVEvu6-ryv85tEb4gFvcI Visit redandgreen blog for more Tutorials ========================================= ? http://redandgreen.co.uk/about/blog/ Subscribe to the YouTube Channel ================================= ? https://www.youtube.com/c/DrPiCode Follow on Twitter - to get notified of new videos ================================================= ? https://twitter.com/RngWeb ? Become a patron ? ? https://www.patreon.com/drpi ? Buy Dr Pi a coffee (or Tea) ? ☕ ☕ ☕ https://www.buymeacoffee.com/DrPi ☕ ☕ ☕ Proxies ================================================= If you need a good, easy to use proxy, I was recommended this one, and having used ScraperAPI for a while I can vouch for them. If you were going to sign up anyway, then maybe you would be kind enough to use the link and the coupon code below? You can also do a full working trial first as well, (unlike some other companies). The trial doesn't ask for any payment details either so all good! ? ? 10% off ScraperAPI : https://www.scraperapi.com?fpr=ken49 ◼️ ◼️ Coupon Code: DRPI10 ◼️ (You can also get started with 1000 free API calls. No credit card required.) Thumbs up yeah? (cos Algos..) #Jinja #networkautomation #python ... https://www.youtube.com/watch?v=FkQoPQuGMxw

While, For, If, Then, but never Why? Computers don't ask why.. As humans we need to ask "Why!" Why?....Watch the video.... Notes: I thought it was Al Sweigart, but it was nother Nostarch writer, Eric Matthes, please read this : ? https://ehmatthes.github.io/pcc_2e/ **If you don't get anything else from this video please take 1 minute to read it. ...."those who have power are desperate to hold on to that power" If you live in the UK also take a look at this: ? https://www.change.org/p/the-department-for-health-and-social-care-stop-the-share-of-nhs-data-and-paid-access-without-informed-consent ** DuckDuckGo shows an Amazon advert as 1st result ** Google shows a song on spotify as 1st results Ecosia actually shows the dictionary definition..... ? https://www.ecosia.org/search?q=why Bing and Yahoo do actually return the dictionary defintion as well. Visit redandgreen blog for more Tutorials ========================================= ? http://redandgreen.co.uk/about/blog/ Subscribe to the YouTube Channel ================================= ? https://www.youtube.com/c/DrPiCode Follow on Twitter - to get notified of new videos ================================================= ? https://twitter.com/RngWeb ? Become a patron ? ? https://www.patreon.com/drpi Buy Dr Pi a coffee (or Tea) ☕ https://www.buymeacoffee.com/DrPi Proxies ================================================= If you need a good, easy to use proxy, I was recommended this one, and having used ScraperAPI for a while I can vouch for them. If you were going to sign up anyway, then maybe you would be kind enough to use the link and the coupon code below? You can also do a full working trial first as well, (unlike some other companies). The trial doesn't ask for any payment details either so all good! ? ? 10% off ScraperAPI : https://www.scraperapi.com?fpr=ken49 ◼️ Coupon Code: DRPI10 (You can also get started with 1000 free API calls. No credit card required.) Thumbs up yeah? (cos Algos..) ... https://www.youtube.com/watch?v=9U50WsCeNiM

A short video covering the Feynman technique and some tips on active recall. If you want to learn more check out : https://fs.blog/feynman-technique. Test you can actually implement an example from scratch rather than refer to StackOverflow. If you can write a Class or create an ML model, perfectly can you actually use it - sometimes you may put so much effort into the first part you go wrong when you try and use what you've coded. ? Step 1: Choose a concept you want to learn about. ? Step 2: Explain it to a 12-year-old (or try it in VS Code) ? Step 3: Reflect, Refine, and Simplify ? Step 4: Organise and Review Go back and revisit the bits you can't write or code from memory. Even if you are learning Python, the topic of this video may be more important than any Python video you ever watch. Test/Check everything you think you know. ✅ Become a patron : ? https://www.patreon.com/drpi Buy me a coffee (or Tea) ☕ https://www.buymeacoffee.com/DrPi If you want a fast VPS server with Python installed check out : https://webdock.io/en?maff=wdaff--170 Pytest with FastAPI course on "TestDriven.io": ------------------------------------------------------------------------- https://testdriven.io/courses/tdd-fastapi/?utm_source=python360 https://testdriven.io/courses/scalable-fastapi-aws/?utm_source=python360 https://testdriven.io/courses/fastapi-celery/?utm_source=python360 Thumbs up yeah? (cos Algos..) #learningtechniques #learntocode #pythonprogramming ... https://www.youtube.com/watch?v=AA3EcUZ-E1g