teleren/devto huggingface dataset:
Journey from 2020 to 2021
Tags: devjournal, beginners, showdev
Published: 2021-01-03 16:52:30

---
title: Journey from 2020 to 2021
published: true
description: Life Journey
tags: journal, beginners , showdev
series: Life Journey
cover_image: https://i.ibb.co/52K3z8c/2020-to-2021.png

---
Hey there 🖐,
It is that time of the year again. Happy holidays. Sun had to witness earth rotating for nothing again. Also i thought adding a post summarizing what i have done throughout the year and some of the objectives for the future year to come.

## I changed my job 🏢
- - - -
## Published 46 posts in dev.to until now ✍
- - - -
* [Machine learning](https://dev.to/sandeepbalachandran/machine-learning-introduction-400o) (22)
* [Angular](https://dev.to/sandeepbalachandran/angular-dark-fate-48dp)(7)
* [Laravel](https://dev.to/sandeepbalachandran/how-to-generate-pdf-and-send-it-on-mail-in-laravel-5-8-b8j)(2)
* [Javascript](https://dev.to/sandeepbalachandran/javascript-journey-31hb)(1)
* Miscellaneous(14)


## Started maintaining a number of open-source projects. 🎉
- - - -
* ngx-sand-typeahead ✅ [Go to Github](https://github.com/SandeepBalachandran/ngx-sand-typeahead)
  * A typeahead package for angular framework

* Pytheract ✅ [Go to Github](https://github.com/SandeepBalachandran/Pytheract)
  * An Image extraction tool using tesseract and  pytesseract wrapper.
* Pythonophobia ✅[Go to Github](https://github.com/SandeepBalachandran/Pythonophobia)
  * A collection of python programs listed with beginners,average, advanced developers.

## What I learned in 2020
- - - -
* Angular
  * Basic unit testing using Jasmine and Karma
  * Angular library creation
  * Authentication with keycloak
  * Keycloak theme customization
  * Concepts of multitenancy with keycloak
* Basic understandings of data Science with Python
* Basics of
    * Numpy
    * Matplotlib
    * pandas
* Machine Learning concepts
   * Basics of scikit
   * Intro to tensorflow.

* Morse code  ( a little ). Required pen and paper 🤣
* More spanish lesssons and vocabulary 💪
* Juggling with 3 and 4 balls 🥎🥎🥎🥎


## What I want to learn/do in 2021
- - - -
* Data structures and algorithms
* System design
* Tensorflow 2 concepts
* Angular Advanced Concepts
 * Microfrontend
 * Multitenancy 
 * Server side rendering.
* Advancing in spanish language.
* Starting my own blog.
* To build a good workstation

Thtats pretty much the end of it. Share your achievements and objectives if interested. 

Later then .
A machine learning app to identify your apparel
Tags: dohackathon, machinelearning
Published: 2021-01-03 16:49:18

## What I built
I have built an application which can detect whether you are wearing a t-shirt or a shirt via webcam.
### Category Submission: 
Built for Business

### App Link
https://clothdetector-kegak.ondigitalocean.app/

### Screenshots
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/fbxyea0ptgf40nsmwdl0.png)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/yutyvwjam3hmn00v8343.png)

### Description
User has to stand in front of the camera wearing a shirt or a t-shirt and then the application will automatically detect the type of clothing apparel. This app asks for camera permission which a user has to allow. All the rendering and detection part is done on client-side. It is basically a client-side application no data is stored on the server.

### Link to Source Code
https://github.com/sisodiya2421/ClothDetector
### Permissive License
[MIT License](https://github.com/sisodiya2421/ClothDetector/blob/master/LICENSE)

## Background
I am currently learning the basics of machine learning and then one day I came across an awesome tool [Teachable Machine](https://teachablemachine.withgoogle.com/) which lets you build your own custom machine learning model and teaches you the basic concepts of Machine Learning using tensorflow.js. Since I work in a fashion-tech company, from there I got the idea to build something which can detect human clothes using a camera.
### How I built it 
I built it using node.js and p5js library ( a wrapper around tensorflow.js). DigitalOcean's App Platform gave me a platform to easily deploy and test the performance of the application. Not only this project helped me learn about new libraries like P5js and tensorflow.js but also the javascript language which is new for me. I also learned Key points like epochs and how to attain accuracy during a machine learning training process by building this project. 

### Additional Resources/Info

[P5.js](https://p5js.org/)
[Tensorflow.js](https://www.tensorflow.org/js/)
[Teachable Machine](https://teachablemachine.withgoogle.com/)
Vertical Scroll Navigation Dots for the Side of Any Web Page in 2 Minutes... (Vanilla JS Plugin)
Tags: javascript, css, html, webdev
Published: 2021-01-03 16:43:51

Side navigations really help users keep track of their location on a Web page, especially considering how tall many pages have become with so much content below the fold.

The difficulties associated with these kinds of pages is further exaggerated on mobile devices, whereby content is stretched into the shape of a *mighty sword* that the user must slide down on their own.

Some solutions to this involve breaking the page into full screen sections that can be navigated between, kind of like a PowerPoint presentation. But why limit your content to these slides? And why should navigation need to affect layout at all?

**I present [EasyScrollDots](https://github.com/Superhands89/EasyScrollDots)**, which allows the user to click to scroll though sections of the page, and it updates as they scroll.

It's a nice simple **vanilla** JavaScript page scroll plugin that literally just requires you to drop a data attribute on the outer element of each section that should have a dot associated with it...

`<div data-scroll-indicator-title="Hello World">
    Content in my section lorem ipsum dolor...
</div>`

*You should update "Hello World" to represent the title for that section of the page..*

Here's a **[Demo](https://easyscrolldots.primmis.com/)**

> Some of the benefits of EasyScrollDots are that it doesn't let sticky or fixed top navigation bars get in the way when you click  to scroll to a section (even if the navigation bar is only fixed when the user is scrolling upward); and you can set your own offset amount in pixels when you call the plugin.

To call the plugin you just...

```
easyScrollDots({
  'fixedNav': false, // Set to true if you have a fixed nav.
  'fixedNavId': '', // Set to the id of your navigation element if 'fixedNav' is true (easyScrollDots will measure the height of the element).
  'fixedNavUpward': false, // Set to true if your nav is only sticky when the user is scrolling up (requires 'fixedNav' to be true and 'fixedNavId' to be a value).
  'offset': 0 // Set to the amount of pixels you wish to offset the scroll amount by.
});
```

By default, hovering on a dot whilst using a device that supports hover will show the title for that section, whilst touch devices only show the dots. And even IE11 is supported for a laugh...

`@media (hover: hover), (-ms-high-contrast: none), (-ms-high-contrast: active) {
	:D :D
}`

From a performance perspective, it's under 4kb of JavaScript and under 2kb of CSS. It's throttled too so there's zero impact on user experience :)

Here is the GitHub page: https://github.com/Superhands89/EasyScrollDots

And Thanks for Reading!! :D
How to Resize a Table in Excel ~ A Complete Tutorial!!
Tags: excelpreface, excelbasics, exceltutorials, resizeatable
Published: 2021-01-04 13:42:09

---
title: How to Resize a Table in Excel ~ A Complete Tutorial!!
published: true
date: 2021-01-03 16:32:13 UTC
tags: ExcelPreface,ExcelBasics,ExcelTutorials,Resizeatable
canonical_url: https://geekexcel.com/resize-a-table-in-excel/
---

So far, we have seen [how to filter and sort a table in Excel](https://geekexcel.com/sort-a-table-excel/). Likewise, here we are going to learn **how to resize a table in Excel**. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Steps to resize a table:

Let’s see the [simple steps to modify](https://geekexcel.com/shortcut-keys-to-display-modify-cell-style-dialog-box-in-excel-365/) the table into the desired size in Excel.

- First, you need to create the table in your Excel Sheet.

![Create a Table](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Create-a-Table.png)<figcaption id="caption-attachment-20622">Create a Table</figcaption>

- Then, you need to move your mouse to the **sizing handle** in the lower-right corner of the table.
- When moving the cursor to the sizing handle, you can see the white cross will turn to a double arrow as per the given image.

![Move Cursor](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Move-Cursor.png)<figcaption id="caption-attachment-20623">Move Cursor</figcaption>

- Now, you need to drag the table size to your desired range and release your mouse

![Resize](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Resize.png)<figcaption id="caption-attachment-20624">Resize</figcaption>

- It will create the table as per your selected range.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-4.png)<figcaption id="caption-attachment-20625">Result</figcaption>

## Wrap-Up:

From this tutorial, we explained the step-by-step procedure to **resize the table in Excel**. Hope you like this article. If you have any **issue** regarding this article or any unresolved **query,** please comment in the **comment** box below. We will assist you. Thank you!!

### Read Also:

- **[How to Convert 2-Dimensional/Cross Table to List in Excel Office 365?](https://geekexcel.com/how-to-convert-2-dimensional-cross-table-to-list-in-excel-office-365/)**
- **[EXCEL TABLES- A Walk Through of using Tables in Excel 365](https://geekexcel.com/create-excel-tables-quickly-in-microsoft-excel-365/)**
📊 Design a Chart in Excel Office 365 ~ Step-by-Step Procedure!!
Tags: excelpreface, designachart, excelbasics, exceltutorials
Published: 2021-01-04 13:42:01

---
title: 📊 Design a Chart in Excel Office 365 ~ Step-by-Step Procedure!!
published: true
date: 2021-01-03 16:30:07 UTC
tags: ExcelPreface,Designachart,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/design-a-chart-in-excel/
---

A [chart](https://geekexcel.com/excel-charts-types-in-office-365/) is a tool you can use in Excel to communicate data graphically. Charts allow your audience to see the meaning behind the numbers, and they make showing comparisons and trends much easier. Now, this tutorial is talking about **how to design a chart in Excel**. Let’s get started!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## How to design a chart?:

After creating a chart, you will not satisfy with the design or [color](https://geekexcel.com/how-to-change-background-color-in-microsoft-excel-365/). Let’s see the below steps to change the chart style, and color in Excel.

- First, [create the chart](https://geekexcel.com/what-is-the-shortcut-to-create-chart-in-new-worksheet-in-excel-365/) on your worksheet.

![Create a chart](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/create-a-chart.png)<figcaption id="caption-attachment-20631">Create a chart</figcaption>

- Then, click anywhere in the chart, and you will see the **“Chart Style”** button on the right corner of the chart.

![Chart Style option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Click-style-option.png)<figcaption id="caption-attachment-20632">Chart Style option</figcaption>

- It will expand the drop-down list that contains a different type of chart list.

![Different chart designs](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Different-chart-designs.png)<figcaption id="caption-attachment-20633">Different chart designs</figcaption>

- Now, you can select the chart style as you wish.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-5.png)<figcaption id="caption-attachment-20634">Result</figcaption>

## Conclusion:

So yeah guys, this is how you can **design your chart in Excel**. Hope you like this article. Let me know if you have any **doubts** regarding this article or any other article on this site. Thank you so much for visiting our site!! ![🙏](https://s.w.org/images/core/emoji/13.0.1/72x72/1f64f.png)

### Read Ahead:

- **[Excel Charts Types in Office 365!](https://geekexcel.com/excel-charts-types-in-office-365/)**
- **[How to Create a Line Chart in Excel Office 365 with Simple Example!!](https://geekexcel.com/how-to-create-a-line-chart-in-excel-office-365-with-simple-example/)**
- **[Create a Sunburst Chart in Excel Office 365 with an Example!!](https://geekexcel.com/create-a-sunburst-chart-in-excel-office-365-with-an-example/)**
- [**Create a Stacked Bar Chart in Excel Office 365 Quick Steps!!**](https://geekexcel.com/create-a-stacked-bar-chart-in-excel-office-365-quick-steps/)
How to Sort a Table in Excel Office 365 ~ Complete Tutorial!!
Tags: excel, excelbasics, excelpreface, exceltutorials
Published: 2021-01-05 15:32:25

---
title: How to Sort a Table in Excel Office 365 ~ Complete Tutorial!!
published: true
date: 2021-01-03 16:26:58 UTC
tags: Excel,ExcelBasics,ExcelPreface,ExcelTutorials
canonical_url: https://geekexcel.com/sort-a-table-excel/
---

In the previous post, we have learned the steps to [filter the table](https://geekexcel.com/filter-a-table-in-excel/). Here, we will see **how to sort a table in Excel**. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Steps to sort a table:

Once you have the table in your [worksheet](https://geekexcel.com/structure-of-excel-worksheet/), you can follow the below steps for sorting the values in the table.

- In the table, you need to click the small triangle right after the column name.

![Select the table](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select-the-table.png)<figcaption id="caption-attachment-20582">Select the table</figcaption>

- Then, it will expand the drop-down window as shown in the below image.

![Drop-Down list](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Drop-Down-list.png)<figcaption id="caption-attachment-20583">Drop-Down List</figcaption>

- In the window, you need to select “ **Sort Largest to Smallest** ” or “ **Sort Smallest to Largest”** and click the **“OK”** button. For example, we will select “Sort largest to smallest”.

![Sort largest to smallest](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Sort-largest-to-smallest.png)<figcaption id="caption-attachment-20589">Sort largest to smallest</figcaption>

- Now, you will see the table in descending order (i.e. largest to smallest).

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-2.png)<figcaption id="caption-attachment-20590">Result</figcaption>

## Verdict:

In this way, you can learn how to **sort the table in Excel Office 365**. Let me know if you have any **doubts** regarding this article or any other article on this site. I reply to queries frequently. To learn more, check out **[Geek Excel](https://geekexcel.com/)****!!**

### Read Also:

- **[EXCEL TABLES- A Walk Through of using Tables in Excel 365](https://geekexcel.com/create-excel-tables-quickly-in-microsoft-excel-365/)**
- **[Excel Shortcut: INSERT TABLE in the Worksheet in Excel 365!!](https://geekexcel.com/ms-excel-shortcut-to-insert-table-in-the-worksheet/)**
- [**5+Steps to DELETE BLANK ROWS in Microsoft Excel 365**](https://geekexcel.com/5steps-to-delete-blank-rows-in-microsoft-excel-365/)
- [**Shortcut to SELECT TABLE in Microsoft Excel 365!**](https://geekexcel.com/keyboard-shortcut-to-select-table-in-microsoft-excel-365/)
How to Filter a Table in Excel ~ A Complete  Guide!!
Tags: excelpreface, excelbasics, exceltutorials, filteratable
Published: 2021-01-03 16:42:28

---
title: How to Filter a Table in Excel ~ A Complete  Guide!!
published: true
date: 2021-01-03 16:21:41 UTC
tags: ExcelPreface,ExcelBasics,ExcelTutorials,Filteratable
canonical_url: https://geekexcel.com/filter-a-table-in-excel/
---

[**Filtering a table**](https://geekexcel.com/easy-shortcuts-for-tables-and-filters-options-in-excel-365/) is nothing but **temporarily hiding** the rows that do not want to see. In this tutorial, we will see how to filter a table in Excel. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## Steps to filter a table:

Once you have the table in your worksheet, you can follow the below steps for filtering the values in the table.

- In the table, you need to click the small triangle right after the [column](https://geekexcel.com/definitions-cell-range-row-column/) name.

![Select the table](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select-the-table.png)<figcaption id="caption-attachment-20582">Select the table</figcaption>

- Then, it will expand the drop-down window as shown in the below image.

![Drop-Down list](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Drop-Down-list.png)<figcaption id="caption-attachment-20583">Drop-Down List</figcaption>

- Select the values that you want to [hide](https://geekexcel.com/how-to-unhide-all-rows-and-columns-in-excel-office-365/) from the list.

![Select values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Unselect.png)<figcaption id="caption-attachment-20584">Select values</figcaption>

- Now, you can see the table with the selected values, and the other rows are filtered out.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-1.png)<figcaption id="caption-attachment-20585">Result</figcaption>

## A Brief Summary:

![🤞](https://s.w.org/images/core/emoji/13.0.1/72x72/1f91e.png) Hope you understood how to filter the table in Excel Office 365. If you have any **doubts** regarding this topic or any other Excel VBA related topic, ask in the **comments** section below. I reply to queries frequently. To learn more, check out **[Geek Excel](https://geekexcel.com/)****!!**

### Read Also:

- **[EXCEL TABLES- A Walk Through of using Tables in Excel 365](https://geekexcel.com/create-excel-tables-quickly-in-microsoft-excel-365/)**
- **[Easy Shortcuts for Tables and Filters Options in Excel 365!!!](https://geekexcel.com/easy-shortcuts-for-tables-and-filters-options-in-excel-365/)**
- [ **5+Steps to DELETE BLANK ROWS in Microsoft Excel 365**  
](https://geekexcel.com/5steps-to-delete-blank-rows-in-microsoft-excel-365/)
Convert a Table to the Data Range in Excel Office 365!!
Tags: excelpreface, coverttableintodatar, excelbasics, exceltutorials
Published: 2021-01-03 16:44:06

---
title: Convert a Table to the Data Range in Excel Office 365!!
published: true
date: 2021-01-03 16:19:48 UTC
tags: ExcelPreface,Coverttableintodatar,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/convert-table-to-data-range/
---

The [table](https://geekexcel.com/how-to-update-merge-tables-by-matching-column-from-two-worksheets-workbooks-in-excel/) is a useful feature for us to do some operations in Excel. To **convert the table to the data range** or vice versa, Excel provides some easy ways for us to use. Please know more details in this article. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## How to convert a table to the data range:?

- First, you need to create the table in your [worksheet](https://geekexcel.com/excel-office-365-worksheet-options/) and click anywhere in the table.

![Click the table](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Select-a-table.png)<figcaption id="caption-attachment-20575">Click the table</figcaption>

- You can see the **“Design”** tab or **“Table**   **Design** ” tab from the ribbon. (It will depend on your Excel Version).
- Here, you need to click the **“Convert to Range”** option in the **“Tools”** section.

![Table Design](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Selet-table-tool.png)<figcaption id="caption-attachment-20576">Table Design</figcaption>

- Then a prompt box will pop out, and click the **Yes** button.

![Select Yes](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/select-Yes.png)<figcaption id="caption-attachment-20577">Select Yes</figcaption>

- Now, the selected table will be converted to the normal range without losing data or formatting.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result.png)<figcaption id="caption-attachment-20578">Result</figcaption>

## Wind-Up:

From this tutorial, you can get to know the simple steps for **converting the table into a data range in Excel**. If you have any **doubt** regarding this article or have any other **questions** related to Excel, let me know in the **comments** section below. To learn more, check out **[Geek Excel](https://geekexcel.com/)****!!**

### Related Articles:

- **[Excel Shortcut: INSERT TABLE in the Worksheet in Excel 365!!](https://geekexcel.com/ms-excel-shortcut-to-insert-table-in-the-worksheet/)**
- **[Select Table Row Using Shortcuts in Microsoft Excel 365!!](https://geekexcel.com/shortcut-keys-to-select-table-row-in-microsoft-excel-365/)**
- [**Shortcut to SELECT TABLE in Microsoft Excel 365!**](https://geekexcel.com/keyboard-shortcut-to-select-table-in-microsoft-excel-365/)
How to Get Full File Name and Path in Excel Office 365?
Tags: excelbasics, getthecurrentworkboo, exceltutorials
Published: 2021-01-03 17:06:58

---
title: How to Get Full File Name and Path in Excel Office 365?
published: true
date: 2021-01-03 16:18:08 UTC
tags: ExcelBasics,getthecurrentworkboo,ExcelTutorials
canonical_url: https://geekexcel.com/how-to-get-full-file-name-and-path-in-excel-office-365/
---

Here, we are going to explore how to get the current workbook name, and its absolute path using the [CELL](https://geekexcel.com/definitions-cell-range-row-column/) function. Follow the instructions given in this article and achieve this task quickly.
## CELL Function – Syntax & Explanation:

- The Excel **CELL function** returns information about a cell in a worksheet.
- Syntax of Cell function is as follows.

**=[CELL](https://geekexcel.com/use-cell-function-in-microsoft-excel-365-simple-methods/)(info\_type, [reference])**  

- Let’s see the formula for finding the current workbook name, and path in the worksheet.
- Refer to the below given formula.

**=[CELL](https://geekexcel.com/use-cell-function-in-microsoft-excel-365-simple-methods/)(“filename”,B1)**  

## Practical Example:

- In the below image, you can see the formula in the **cell B2.**

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-the-formula.png)<figcaption id="caption-attachment-20569">Enter the formula</figcaption>

- Then, it will return the output as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/EXCEL_9HkgWhgKO0.png)<figcaption id="caption-attachment-20570">Output</figcaption>

## Sum-Up:

In the above article, you can easily understand the steps to **get the current workbook name, and its absolute path using the CELL function**. Drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!