Datareads

Excel Tables are powerful data objects which make life easier for users. It improves data accessibility and analysis with the help of derived rows and columns. Before jumping to the benefits, I want to show how we convert data to an excel table. The sample data used in my example has been taken from  https://www.contextures.com/xlsampledata01.html .  Converting data to excel table -  Select the data range, go to the Home tab in the ribbon, select Format as Table, and select any format. It will convert your data to an excel table object. This is what the converted table looks like -  Benefits of this conversion -  1. Sorting and Filtering is more accessible - You can click on the small dropdown next to the column name that you want to sort or filter from. 2. Addition of rows and columns is easier - You can simply add adjacent rows and columns and excel will automatically make them a part of the table. 3. Frozen headers - Table headers are by default frozen. He...

This blog is going to be on Git and a couple of very basic commands to run Git locally in our system. But before that, it is better to bust the myth, that “Git and GitHub are the same things”. This is a very beginner-level misconception to assume Git and GitHub to be the same thing. Though they are related to each other, both of them serve different purposes. According to Wikipedia, Git is software for tracking changes in any set of files, usually used for coordinating work among programmers collaboratively developing source code during software development. In simple terms, Git is a version control system. While on the other hand, GitHub is a hosting platform where you can host your git repositories and share them with others. I guess the basic definition is clear, now we can take it to the next step.  Downloading Git in your local system is very easy. You may follow any of the tutorials present on the Internet to install Git or maybe you can simply start installing on your ow...

I was sitting in the second row as our class teacher called roll numbers for attendance. With each roll number called, I would turn around to see the face, which is supposed to be familiar as I meet them every day, but surprisingly brought a smile to my face as if I am meeting them after a long time. My best friend was sitting beside me too, just like any perfect day. Everyone talked to each other without our teacher stopping us, and the classroom seemed like a warm and cordial place to socialize. As time passed, not realizing the exact reason, I didn't want the period to get over. I didn't want that space to be disturbed. There was an urge in me to stop the time then and there. The sound of my alarm clock woke me up. Suddenly everything started to make sense. My "turning around" to see the faces, my "urge to stop time" everything seemed to be coherent. I was dreaming about my school days after five years of graduation. That's when I realized that I ha...