Automate anything and everything

Image for post
Image for post
Photo by Samuel Sianipar on Unsplash

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. …


Reading is fun!

Image for post
Image for post
Photo by Thought Catalog on Unsplash

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.

And Then There Were None — Agatha Christie

Image for post
Image for post

Agatha Christie is known for bringing murder mysteries on the pages. Published in 1939, Agatha Christie’s And Then There Were None is gripping, mysterious, and keeps you on the edge of the seat. The book’s major plot revolves around the minstrel song(Ten Little Indians). An unknown host invites eight people to a small secluded island. When they arrive there, they are met by a butter couple. …


Start writing elegant code!

Image for post
Image for post
Photo by David Rangel on Unsplash

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.

Swapping Variable

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…


My Review

Stitched with writing pieces full of grief!

Image for post
Image for post
The White Book — Babbel

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. …


Combining dataframes with Pandas!

Image for post
Image for post
Photo by Ilona Froehlich on Unsplash

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. …


Working with re module functions

Image for post
Image for post
Photo by Tengyart on Unsplash

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.

  • Searching
  • Substitution
  • Utility

Searching functions

  • re.search() — scans for a pattern match
  • re.match() — look for a match at the string’s beginning
  • re.findall() — list of pattern matched in the…


Pattern matching with Regex

Image for post
Image for post
Photo by Ömürden Cengiz on Unsplash

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.

Since them, regular expressions or regexes have boomed in programming. From Python, Java to JavaScript, regexes have adopted regular expressions. So is the case with text editors and many Unix tools.

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. …


e-learning doesn’t insult traditional system

Image for post
Image for post
Photo by Markus Winkler on Unsplash

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.

1. E-learning is too techy

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. …


Using the PyPDF2 library

Image for post
Image for post
Photo by Annie Spratt on Unsplash

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. …


An interview guide for college students!

Image for post
Image for post
Photo by Gemma Evans on Unsplash

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 ->…

Vishal Sharma

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store