teleren/devto huggingface dataset:
My journey to being a certified data engineer! What steps am i taking?
Tags: datascience, career, womenintech, certifications
Published: 2020-09-07 12:10:14

So some of the goals am looking forward to achieving this year include expanding my skills and becoming a certified azure data Engineer.
With the Mentorship i am getting from the people around me i think that i am finally ready.

Professionally i am a Snr ERP engineer. We deal with a lot of data on a large scale, and it is one of my passions to be able to process and learn from my data and  tell stories that lie herein.

I am going to take you trough my journey on what skills i have achieved so far and how. Please feel free to share what you have on your side too.

#What is a Data Engineer
A data engineer is an individual who develops systems that are able to power  machine learning and AI analytics
#What are some of your Roles
Some of your roles will include creating processes that will automate -data acquisition ,Transformation
 data transformation, data migration, data verification, data modeling, and data mining---Define each

#Programming languages and Learning process
Personally i use python, i have attended a few boot camps and read about the theoretical .However ,it is obvious that if you don't practice your skills you can easily forget what you have learnt in the long run. Personally i have made this mistake in the  past but it is not too late.

##Certifications
I intend to achieve the **Microsoft Certified: Azure Data Engineer Associate**.To achieve this i have to do two exams:-**DP 200** Implementing Azure Data Solution  and **DP 201** Designing an Azure Data Solution.

The skills measured include;

*Implement data storage solutions
*Manage and develop data processing
*Monitor and optimize data solutions
*Design Azure data storage solutions
*Design data processing solutions
*Design for data security and compliance
I am using Microsoft Learn as my learning path [Link](https://docs.microsoft.com/en-us/learn/certifications/azure-data-engineer?wt.mc_id=learningredirect_certs-web-wwl)

##After..
Finish building my  portfolio on GitHub.(Will do an article on this too)
Write blogs about data science; create a medium article and finally earn trough my articles.

Please feel free to share what you have on your side too or your thoughts .
Thank you!!!
Key Role of Android in IOT
Tags: android, iot, java, linux
Published: 2020-09-07 12:07:07

Android happens to be among the most well-known and most used methods among the most prominent operating systems and devices. Approximately 50% of the world’s e total population is using Android right now thanks to the numerous benefits. Mobile technology is capable of modifying communication in several ways.

 
Why is Android App Development so sought after?

At present, you’ll come across a higher number of mobile users as compared to PC users. The mobile technology division has opened up several opportunities for each particular organization to communicate with its intended audience. This depicts that Android app development services happen to be the most sought-after services in the present IT sector.

The number of mobile app developers catering to the Android app development services is numerous these days. The service companies come with a professional team of Android developers having updated knowledge regarding the most recent trends helping in producing top-class applications out there.

 
For what reason is Android so popular?

There is no doubt regarding the simplicity of Android. However, for what reason is Android so well-known right now? Perhaps the most notable reason behind the popularity of this operating system is that it is entirely free. Right from the very beginning, Android is free, and Google will keep it free in the upcoming days. This has attracted the hardware manufacturers worldwide to produce inexpensive smartphones powered by a free OS that happens to be Android.

Apart from this, Android is likewise an open-source. As compared to similar mobile operating systems that are safeguarded by different laws and copyrights, Google has kept Android open. This allows a large number of talented and active developers to give their best. Innovative ideas are being implemented now and then with plenty of intelligent brains functioning for the operations.

Reasons why Android is at the forefront of the Internet of Things


IoT is driven by applications
IoT has been developed on Java
The sensor
Device
The Android IoT ecosystem
Transfer of data
Program

Learn in details here:https://www.rlogical.com/blog/key-role-of-android-in-internet-of-things/
How to Separate Numbers After a Symbol in Excel Office 365?
Tags: excelpreface, separatenumbersafter
Published: 2020-09-08 06:37:45

---
title: How to Separate Numbers After a Symbol in Excel Office 365?
published: true
date: 2020-09-07 12:05:53 UTC
tags: ExcelPreface,Separatenumbersafter
canonical_url: https://geekexcel.com/how-to-separate-numbers-after-a-symbol-in-excel-office-365/
---

## Separate Numbers After a Symbol in Excel:

In this article, we are going to see how to **Separate Numbers After a Symbol in Excel Office 365**. 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 Separate Numbers After a Symbol:

Do as follows.

## Syntax:

**=[RIGHT](https://geekexcel.com/how-to-use-right-function-in-microsoft-excel-365/)(A2, [SEARCH](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)(“#”, A2, 1))**

### Syntax Explanation:

- Here, [**RIGHT**  **Function**](https://geekexcel.com/how-to-use-right-function-in-microsoft-excel-365/) is used to find the value in the **cell A2** and the[**SEARCH Function**](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)is used to find the “ **#** ” symbol.
- You can also use other special characters such as **$, %, \*, ^, &,** and so on.

### Example:

Let’s see the below example to make it clear.

- In the below screenshot, you can see the serial numbers are given in **Column B** , and its separated values are listed in **Column C**.
- Here, we used ( **#, $, &, ^** ) these special characters.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_85AACIBi9F.png)<figcaption id="caption-attachment-13483">Example</figcaption>

## Wrap-Up:

In this short article, you can clearly understand the steps to **Separate Numbers After a Symbol in Excel Office 365**. Kindly, leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Create a New Workbook in Excel Office 365?- {Two Easy Ways}](https://geekexcel.com/how-to-create-a-new-workbook-in-excel-office-365-two-easy-ways/)
- [How to Fix #DIV/0! Error in Excel Office 365? – [with Example]](https://geekexcel.com/how-to-fix-div-0-error-in-excel-office-365-with-example/)
Automating deployment with React and Firebase and GitHub actions!
Tags: actionshackathon
Published: 2020-09-07 12:02:03

# **My Workflow**


Automating the deployment of your side-projects is one of the best things you could for your future self. Also known as **Continuous deployment** or CD. In this blog, we will be using Firebase for free hosting and Github actions for continuous deployments.


If you are here then you probably know about firebase, its a development platform by Google that offers services such as hosting, realtime database, cloud storage, etc.


If you have never deployed a react app before with firebase, there are tons of tutorials out there but here is [One](https://www.youtube.com/watch?v=ji6urVl6oP4)


**I wrote a GitHub action to build and deploy my side project to firebase when pushed to its repo.**

When writing your own action, make sure you have your `FIREBASE_TOKEN` ready. You can also generate your own by doing this on your terminal inside your repo : 

```
firebase login:ci
``` 
and add this token to the secrets of your GitHub repo as `FIREBASE_TOKEN`

# **Submission Category:** 

**DIY Deployments**


# **Yaml File or Link to Code**

```
name: Firebase Deploy
on:
  push:
    branches:
      - master

jobs:
  build:
    name: Build
    runs-on: ubuntu-latest
    steps:
      - name: Checkout Repo
        uses: actions/checkout@master
      - name: Install Dependencies
        run: npm install
      - name: Build
        run: npm run build
      - name: Archive Production Artifact
        uses: actions/upload-artifact@master
        with:
          name: build
          path: build
  deploy:
    name: Deploy
    needs: build
    runs-on: ubuntu-latest
    steps:
      - name: Checkout Repo
        uses: actions/checkout@master
      - name: Download Artifact
        uses: actions/download-artifact@master
        with:
          name: build
          path: build
      - name: Deploy to Firebase
        uses: w9jds/firebase-action@master
        with:
          args: deploy --only hosting
        env:
          FIREBASE_TOKEN: ${{ secrets.FIREBASE_TOKEN }}
```
Here is the link to the main.yml file : [main.yml](https://github.com/tanvesh01/CoronaTrackerApp/blob/master/.github/workflows/main.yml)

### **Here is the repo**

{% github tanvesh01/CoronaTrackerApp %}


# **Additional Resources / Info**

A similar tutorial for Angular folks :
[Link](https://fireship.io/snippets/github-actions-deploy-angular-to-firebase-hosting/)
Sometimes you just have to ship it
Tags: books, shipit
Published: 2020-11-03 04:36:35

---
title: Sometimes you just have to ship it
published: true
date: 2020-09-07 10:45:00 UTC
tags: books,shipit
canonical_url: https://letterstoanewdeveloper.com/2020/09/07/sometimes-you-just-have-to-ship-it/
---

Dear new developer,

For me, there comes a point at the end of every project where I’m just sick of it. I’m sick of the project. I’m sick of the technology. I’m sick of project management system. I’m sick of the code.

Sometimes, I just want to see the whole thing burn. Or better, just ship it.

Now, I think that there are two solutions to this problem, and which one you pick depends on your timeline. The first is to take a step back. Talk to a team mate. Work on something else. Talk a walk. Take an extra half hour for lunch.

This may give you perspective to help you dive back in and add just a bit more polish. That polish, which may take the form of additional UX refinement, testing, or even wordsmithing the help messages or marketing text, can help make the project shine.

That’s what I call ‘running through the finish line’ where you want to leave it all on the field. That doesn’t mean you don’t make compromises or that you won’t revisit decisions, but it does mean that you do the best you can. Sometimes to put in that final effort, you need to take a break.

The other choice is to just ship it. This is a good option when you are up against a deadline. It also helps if you know you are a perfectionist and/or afraid of putting your work out there. Nothing is perfect and if your work never sees the light of day because you can’t accept that, the world is losign out. Finally, it can help if you take that time off, acquire that perspective and know that you’re done with this phase of the work.

I just [published a book](https://letterstoanewdeveloper.com/the-book/). It was released on Aug 16. I’m very proud of it, but there were times when I was just plain sick of it. I ended up taking some time away from it and that helped me make sure it was the best book it could be.

When you are working through the final bits of a project, sit back and get that perspective. And then, ship it!

Dan
Hiring!
Tags: hiring
Published: 2020-09-07 12:01:44

Hey guys! hope you are all doing fine.

We have a couple of open positions at the team I am in charge of, I thought about dropping them here, probably someone it's looking for a new challenge.

Backend engineer: https://company.trivago.com/jobs/r4575346002/

Fullstack engineer:https://company.trivago.com/jobs/r4805198002/

GCP Engineer: https://company.trivago.com/jobs/r4470015002/

If you wanna discuss feel free to reach me on [twitter](https://twitter.com/VictorAvelar) or [linkedin](https://linkedin.com/in/victoravelar).
Daily Developer Jokes - Monday, Sep 7, 2020
Tags: jokes, dailydeveloperjokes
Published: 2020-09-07 12:00:05

---
title: "Daily Developer Jokes - Monday, Sep 7, 2020"
description: "Check out today's daily developer joke! (a project by Fred Adams at xtrp.io)"
series: "Daily Developer Jokes"
cover_image: "https://private.xtrp.io/projects/DailyDeveloperJokes/thumbnail_generator/?date=Monday%2C%20Sep%207%2C%202020"
published: true
tags: #jokes, #dailydeveloperjokes
---

Generated by Daily Developer Jokes, a project by [Fred Adams](https://xtrp.io/) ([@xtrp](https://dev.to/xtrp) on DEV)

___Read about Daily Developer Jokes on [this blog post](https://xtrp.io/blog/2020/01/12/daily-jokes-bot-release/), and check out the [Daily Developer Jokes Website](https://dailydeveloperjokes.github.io/).___
### Today's Joke is...
![Joke Image](https://private.xtrp.io/projects/DailyDeveloperJokes/public_image_server/images/5e125964dfaa7.png)

---
*Have a joke idea for a future post? Email ___[xtrp@xtrp.io](mailto:xtrp@xtrp.io)___ with your suggestions!*

*This joke comes from [Dad-Jokes GitHub Repo by Wes Bos](https://github.com/wesbos/dad-jokes) (thank you!), whose owner has given me permission to use this joke with credit.*

<!-- 
Joke text:
___Q:___ What is React's favorite movie genre?

___A:___ Suspense
 -->
[Coming Soon] GitEye: Now "watch" every single file
Tags: opensource, git, javascript, node
Published: 2020-09-07 11:42:48

For past few weeks I've been developing GitEye which is a chrome extension which gives you a "watch" button for a every file in a GitHub repo. Something like  

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

GitEye then pings you when the "watched" files are changed. 

This safely allows me to use latest and greatest dependencies and get notified when some file crucial to the integration is changed.

After I am finished with the development, I will make another post about how GitEye works and it's architecture which I think is really interesting.

Checkout https://www.git-eye.com/ for more details.
Let's Get Started With Azure Static Web Apps
Tags: webdev, serverless, javascript, devops
Published: 2020-09-07 11:18:43

#### 📺 015 - John Papa 🎙️ Frank Boucher

John Papa is joining Frank to talk about [Azure Static Web Apps documentation](https://docs.microsoft.com/en-ca/learn/modules/publish-app-service-static-web-app-api/?WT.mc_id=allaroundazure-blog-jopapa), one of the newest service/product included in Azure. He will explain what it is, what the difference between a "static" and a "regular" website. In short, John will make sure all of us are ready to start playing with Azure Static Web Apps.  

{% youtube 31nFBQg5cAQ %}

Once we are all at the same level John will publish a Svelte JavaScript app and API with Azure Static Web Apps. Then explain how things work to automatically deploy and update a static web application and its API from a GitHub repository. 

Finally, we will talk about all the security, and provide tons of information, [references]((https://docs.microsoft.com/en-ca/learn/modules/publish-app-service-static-web-app-api/?WT.mc_id=allaroundazure-blog-jopapa)) to help you get started.

---

### Useful Links

🔗 [Azure Static Web Apps documentation](https://docs.microsoft.com/en-ca/learn/modules/publish-app-service-static-web-app-api/?WT.mc_id=allaroundazure-blog-jopapa)

🔗 [GitHub](https://github.com/microsoft/swa-community-kit)

🔗 [Learn Module: Publish an Angular, React, Svelte, or Vue JavaScript app and API with Azure Static Web Apps](https://docs.microsoft.com/en-ca/learn/modules/publish-app-service-static-web-app-api/?WT.mc_id=allaroundazure-blog-jopapa)

🔗 [ShopAtHome Demo](https://www.shopathome.dev/home)

🔗 [Azure / static-web-apps](https://github.com/azure/static-web-apps)

🔗 [Post by Burke Holland](https://burkeholland.github.io/posts/static-app-root-domain/)

🔗 [johnpapa / hello-worlds](https://github.com/johnpapa/hello-worlds)

🔗 [VS Code Extension](https://marketplace.visualstudio.com/items?itemName=ms-azuretools.vscode-azurestaticwebapps&WT.mc_id=allaroundazure-blog-jopapa)


### Learn more about John Papa

🔗 [@John_Papa](https://twitter.com/John_Papa)

🔗 [Bio](https://developer.microsoft.com/en-us/advocates/john-papa)

<br />

☁️
Print DVC plots and metrics directly in the terminal
Tags: datascience, dvc, machinelearning, commandline
Published: 2020-09-07 11:05:56

[DVC](https://dvc.org/) has changed the way I handle Machine Learning projects for the better. The `dvc plots diff` command is a great way to see the effect of rounds of experimentation. 

If you use the [kitty](https://sw.kovidgoyal.net/kitty/index.html) terminal, it's possible to print DVC plots directly in the terminal without opening an external program/browser. I wrote a function for the [fish shell](https://fishshell.com/) to simplify this process.

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

Assuming you are using `fish` as your shell, save this code as ~/.config/fish/functions/plotit.fish

{% gist https://gist.github.com/jcpsantiago/9377f1040d11a92f06c6ee7f18423ee4 %}

Then refresh your shell with `source ~/.config/fish/functions/plotit.fish`. Finally, install `jq` and `vega-cli`, if you don't have them in your system yet.

Example usage when inside a DVC-enabled project:
* `plotit pr_curve.csv` -> prints diff plot with width x height of 500px x 500px and x set to row-index and y to the second column of the csv
* `plotit pr_curve.csv recall precision` -> same as above but selects the columns for x and y
* `plotit pr_curve.csv recall precision 800 800` -> with custom width and height in pixels

Enjoy!
Simple PHP Blog with realtime comment updater Like Facebook comment.
Tags: php, facebook, mysql, node
Published: 2020-09-07 10:42:17

Demo: [https://script.adeleyeayodeji.com](https://script.adeleyeayodeji.com)

Developing a realtime comment base system like Facebook and Twitter is fun and cool 
Smiling face with sunglasses

Kick start with my repo: *comment repo* for repo URL
Happy Coding 
Star-struck
Smiling face with sunglasses


> #100DaysOfCode 
> #Web
How do you generate your certificates? 🔏
Tags: discuss, watercooler, productivity
Published: 2020-09-07 10:38:02

---
title: How do you generate your certificates? 🔏
published: true
description: A discuss thread to share tools on how to generate a certificate.
tags: #discuss #watercooler #productivity
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/mdfmwwrraa7vuwk4skob.jpg
---

This Week's post is a little bit different. It's time to learn from your experiences. 

So far, I've been using the keytool from Java and I've found this open-source tool Keystore Explorer (https://github.com/kaikramer/keystore-explorer).

### Do you use a different tool, or how do you even manage the certificates?
How junior dev Can Find Mobile App Jobs
Tags: mobileapp, job, software, developer
Published: 2020-09-07 10:33:37

It's very clear that software developer increases on a daily bases with majority looking for job.

More over, graduates looking to develop apps, there’s plenty to be excited about. There are still plenty of companies developing mobile apps — either in house or through an external partner. Likewise, as app development becomes increasingly complicated, what was once a one-person job is quickly requiring a team.
If you’re graduating college this year, here’s some advice for getting a job in mobile app creation.

1. Adapt Your Mobile App Job Search (and Expectations)
2. Find Out Who is Currently Hiring
3. Make Your Own List
4. Don’t Overlook Traditional Companies and Industries
5. Consider Freelance Work While You Search for a Permanent Job
6. Keep Your Skills Sharp
7. Show, Don’t Tell
8. Sharpen Your Remote Working Skills
9. Solve a Problem
10. Most importantly "Don’t Settle"
Routz directory
Tags: freeclassifiedlisting, classifiedsite, freelistingsite
Published: 2020-09-07 10:13:43

Routz directory is free classified listing in vizag where you can post your free ads for all your business. we provide you the following services in Vizag.

Arts and entertainment
Automobile
Courier and Cargo services
Daily essentials
Education
Event organizing and Services
Electronics and Home appliances
Financial services
Food
Health care
Home decors/services
Hotel & Accommodation
Insurance
Local services
Personal care
Printing and Stationary
Real estate
Shopping
Software solutions
Sports & Games
https://routz.in/
State-driven development of user interface components
Tags: typescript, angular, refactorit
Published: 2020-09-07 10:10:39

I often see code describing the state of the user interface that needs to be simplified.

Let's see code that outputs a list of users.

```html
  <ng-container *ngIf="isLoading && !error">Loading...</ng-container>
  <ul *ngIf="users && users.length && !error">
    <li *ngFor="let user of users">{{user.name}}</li>
  </ul>
  <ng-container *ngIf="!error && !loading && users && !users.length">Nothing found</ng-container>
  <ng-container *ngIf="!isLoading && error">{{error.message}}</ng-container>
```
This code is just awful. It is difficult to read and maintain.
I prefer another way. I used to read about the theory of finite-state machines. The state machine has a finite set of states, and it is in one of these states at each moment.

We have four states of the user's list:
1. Loading
2. Users loaded
3. Users were loaded with errors
4. Users were not founded

Let's describe the state with a discriminated union.
```typescript
type State =
  | { status: 'loading' }
  | { status: 'success', data: IUser[] }
  | { status: 'failed', error: Error }
  | { status: 'not-founded' }
```
Let's rewrite view logic.
```html
  <ng-container *ngIf="state.status === 'loading'">Loading...</ng-container>
  <ul *ngIf="state.status === 'success'">
    <li *ngFor="let user of state.data">{{user.name}}</li>
  </ul>
  <ng-container *ngIf="state.status === 'not-found'">Nothing found</ng-container>
  <ng-container *ngIf="state.status === 'failed'">{{state.error.message}}</ng-container>
```
You can make the state type universal by using generics.
```typescript
type State<TSuccessData> =
  | { status: 'loading' }
  | { status: 'success', data: TSuccessData }
  | { status: 'failed', error: Error }
  | { status: 'not-founded' }
type UsersListState = State<IUser[]>;
```
This code is more reading and self-documenting. Presently your IDE gives better hints for you.
![Code completion example](https://dev-to-uploads.s3.amazonaws.com/i/w1i7zlwtatx1gnnoggyt.png)
![Code completion example](https://dev-to-uploads.s3.amazonaws.com/i/pe4ybj141ugwvrgap3up.png)
Your team will be grateful to you.

P.S. Sorry for my English. It is my first article in English.