VBA (Visual Basic for Applications) is widely used for automating MS-Office products. Most of the time, when you are working with loads of data and want to automate your tasks, VBA comes in very handy.
Last week, I had to work on dozens of workbooks and had to do some process of data cleaning over them. If I would have done it manually by going on each workbook and cleaning it - the same process for dozens of times, it would have sucked all my energy and would have taken hours to get all done and dusted.
To avoid this tedious process of cleaning, I decided to go for a shortcut. And, that was writing a VBA script! And, that made the whole process super fast. I was done with my task in a few minutes. Not only it will save you time, but also bring a serious cut on efforts. And, all it takes will be some good knowledge of VBA script and you will rock at work. …
When I talk to my friends, they always have a major complaint about my reading habits. How can you read all the time? Isn’t it boring? I get these a lot. But, I personally find reading peaceful and a meditating act. Also, it ain’t boring.
That’s why I decided to create a post. If you think reading is boring, I have listed down 5 books that you should read.
Python is at the peak of the programming food chain right now. Because of its readability, versatility, and ease of learning, programmers are showing more and more interest in it. For making your Python journey easier, I have listed 10 tricks that you can use to write more beautiful code.
One of the most used ways to swap two variables is by bringing a ‘temp’ variable into play.
a = 10
b = 20
print("Before Swapping:", a, b)temp = b
b = a
a = temp
print("After Swapping:", a, b)
This will return
Before Swapping: 10 20
After Swapping: 20…
While scrolling Amazon, my buying history suggested me the books of a South Korean writer, Han Kang. I have been reading Haruki Murakami’s work for a long time now. After reading Killing Commendatore, Kafka on the Shore, Men Without Women, Sputnik Sweetheart, and Norwegian Woods, I wanted to try a new way of writing. A new reading style!
And, that’s when Han Kang came in! I came across books like The Vegetarian, Human Acts, and The White Book. THE WHITE BOOK! The name was fascinating and I ordered it right away.
The book talks about personal grief and that’s whole been written in a white POV. When we talk about sadness, depression, being low-key, black is the color we talk about. We talk about the darkness at that time. But, Han Kang’s writing brilliance shows that world through the prism of white color. …
Pandas library comes along with Series and DataFrame objects. And, these two are powerful intermediatory tools to explore and analyze the data. Data from million rows to just dozens, you can create a DataFrame for your analysis.
For a basic idea, Series object can be thought of as a column and a DataFrame object can be seen as a collection of Series in a table-like structure. At times, we get to see separate datasets for analysis. So, it sometimes becomes necessary to unify them. Hence, Pandas methods like merge, join and concatenate come in very handy.
This post discusses those methods and talks about how to use them in our analysis process. …
In the last article, I have talked about regular expressions. Along with it, I focussed on the “re” module in Python which offers tons of regex functionalities. Continuing from where I left, this article will be shedding light on methods in the “re” module which can be used for advanced string analysis.
The previous story majorly worked with re.search(). This story brings a new “re” functions. So, the “re” module comes with three categories of functions.
The story of regular expressions started building up in 1951 when Stephen Cole Kleene, a mathematician who described regular language. And, Ken Thompson used Kleene’s concept for pattern matching in the 1960s.
Regular expressions are used by Pythonistas mostly when they are dealing with strings. Let’s say, you want to find a substring in a string object. Either you can write dozen of lines to do that or use regular expressions directly. …
Since the boom of digitalization, education has seen a massive shift and is changed completely. E-learning platforms have changed the whole concept of education. Now, there is no need to sit under the roof with 50 classmates and learn. Instead, you can stay wherever you want and learn online at your convenience.
Since e-learning is a fresh concept, many myths are lingering in the minds of students. So, I am here to debunk five common myths related to E-learning platforms.
Many people believe that online learning is all about the internet and technology. No, it is not! Just like any educational institute, e-learning’s two strong pillars are students and faculties. …
Python’s flexibility and interactivity lie in the fact that we can use any form of data. From JSON, excel sheets, text files, APIs, or even PDFs, Python lets us play with any form of data.
PDF or Portable Document Format is one of the most common documents sharing format. It can have different elements like text, images, tables, or forms in the file. Since there is a lot happening in a single file, it becomes tedious to extract data out of the PDF file.
In this post, I will be particularly talking about PyPDF2 library that is used to create PDF or extract text out of them in Python. …
Jobs are important! It is coming from a person who has just completed his four years of engineering. It is essential to always be on the toes and ready for every opportunity. In the college/university tenure, a student gets to know other students coming from different backgrounds, start developing new interests, and look for new opportunities in his/her loved niche.
Internships, training, apprenticeship, or fully-fledged job offers, students are seeking these propositions. For that, they have to grind themselves in their respective fields. When the right opportunity comes, they have to go through a never-ending process of hiring.
Subjective Test -> Group Discussion ->…