BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Wise Owl blogs written in 2021 (page 1 of 6)
Showing blogs 1-20 (out of 103)
Looping over rows and columns for a Pandas dataframe
Posted by Andy Brown on 17 December 2021
This blog shows you various ways in which you can loop over the columns of a pandas dataframe, and also explains how to loop over the rows of a dataframe (together with why you should avoid doing this!).
Creating executable files from Python programs using pyinstaller
Posted by Andy Brown on 17 December 2021
A summary of how to package up your Python program (including any referenced modules) into a single executable file.
Answers to (and winner of) our November 2021 logic puzzle
Posted by Andy Brown on 29 November 2021
This month's puzzle was won by Joanne Rushton of Durham County Council - you can see the answer to the logic puzzle set in this short blog.
Posted by Andy Brown on 24 November 2021
Ten reasons why Python is a better programmng language than C# (and most other languages), as well as two reasons why it might not be.
An infographic celebrating 10 years of video tutorials on YouTube
Posted by Andy Brown on 24 November 2021
To celebrate the 10th birthday of our video channel we've created this infographic, showing for example that the number of hours spent watching our videos would have covered 2,949,152 views of the first episode of Squid Game.
The Microsoft Whiteboard is reverting to the old version
Posted by Andy Brown on 24 November 2021
In an almost unprecedented move, Microsoft are cancelling the new Whiteboard launched only last month and reverting back to the old version.
Using the CalendarAuto function effectively in Power BI
Posted by Andy Brown on 24 November 2021
This blog shows how to generate a table which includes not only all of the dates in your data model, but also a range of aggregator columns such as financial year and month name for reporting purposes.
What is SQLCMD mode, and how can you use it?
Posted by Andy Brown on 24 November 2021
You can use SQLCMD mode to parameterise the connection, database name, table name and select columns for a query - and much more besides, as this blog explains.
Posted by Andy Brown on 23 November 2021
This month's update is a biggie, with the introduction of a page navigator and a bookmark navigator, but it's the new formatting pane waiting in preview which will really changes people's lives.
A Power Automate flow to send Xmas gift emails automatically
Posted by Andy Brown on 18 November 2021
Tired of doing repetitive tasks at Christmas? This blog shows you how to create a Power Automate Desktop flow to send emails out to your nearest and dearest programmatically, with each email including instructions on how they should use the gifts they've been given.
Introducing Power Automate Desktop
Posted by Andy Brown on 18 November 2021
Power Automate Desktop allows you to automate any common sequence of tasks that you perform in Windows, and has the potential to change your working life. So what is it?
An update on Windows 11 after a month of use
Posted by Andy Brown on 18 November 2021
After using Windows 11 in anger on his laptop for a month now, Andy Brown takes a moment to sum up his impressions.
The great British beard-off - how Wise Owls lose weight
Posted by Andy Brown on 29 October 2021
Sam and Shaun want to lose weight, and have pledged to cut off their prized beards if they don't meet their targets. You can see the beards, the terms of the contest and updates on their progress (and even join in if you like!) at this blog.
Posted by Andy Brown on 29 October 2021
The Microsoft Whiteboard used for presenting during online meetings has been pretty much rewritten - see whether you like the results (we do).
November 2021 competition: a logic puzzle
Posted by Andy Brown on 29 October 2021
Five space entrepreneurs have missions to different planets scheduled for consecutive years - given the few clues, see if you can work out who is going where, and when!
First impressions of Windows 11
Posted by Andy Brown on 28 October 2021
Windows 11 has a nice clean interface, a few minor new features like snapped layouts, and above all seems to run appreciably faster than Windows 10.
October 2021 newsletter competition: answers and winner
Posted by Andy Brown on 28 October 2021
Last month's competition wsa to shade in a picture of a dinosaur using the numbers provided. Congratulations to Denzil Foakes for winning this month's fifty-pound Amazon voucher (out of the 13 entries submitted, Denzil's was the one picked out of the electronic random hat). You can see the answers here, together with a guide to how to solve this sort of puzzle.
International Keyboard Short-Cut Day 2021 - 10 Windows key short-cuts
Posted by Andy Brown on 28 October 2021
To commemorate the rather dubious International Keyboard Short-Cut Day 2021 (the first Wednesday in November of each year, apparently), we offer the 10 Windows key short-cuts which will save you the most time.
Changes for the October 2021 Power BI Update
Posted by Andy Brown on 28 October 2021
There are virtually no changes in this month's update, but this blog does include details of two new features which slipped through previous monthly update nets: persistent filters and personal bookmarks.
Using personal bookmarks to persist filters
Posted by Andy Brown on 28 October 2021
In Power BI Service you can now create personal bookmarks to retain any changes you've made to filtering for a report.