Forem: Muthu

Best way to avoid multiple if statements in python

Muthu — Sat, 23 Sep 2023 19:48:48 +0000

In general scenario, if you want to check multiple conditions of a simple operation like:

def getFoodPrice(itemName: str) -> float:
  if itemName == "Idli":
      return 10
  if itemName == "Rice":
      return 100
  else:
      raise Exception("Item not found")

In these kinds of scenario we can use Dict object to perform fast and it is very scalable

itemPrice: Dict[str, float] = {
   "idli": 10,
   "rice": 100
}

def getFoodPrice(itemName: str) -> float:
    try:
       return itemPrice[itemName.lower()]
    except KeyError:
       raise Exception("Item not found")

This will reduce the lines of code and improve the scalability. If any new items needs to be added, we can update the dict object not the code.

Find number of `bulb` occurrences from a given string

Muthu — Thu, 15 Sep 2022 11:37:41 +0000

Question:
A string contains bulb string along with others, sometime, it is the continuous one like bulbulb. Find the number of occurrences of bulb.

Ex:
Given: "fbulbhdskjfhdskbulbdsfkjdshfdskbulbulbdsfsdfds"
Expected: 4

Solution:

count = 0
for i, c in enumerate(bulb_str):
  if c == "b" and (bulb_str[i:i+4]) == "bulb":
      count += 1
print(count)

Add all the first elements and second elements to new list from a list of list using `list comprehension`

Muthu — Thu, 15 Sep 2022 11:32:23 +0000

Question:
Add all the first elements and second elements to new list from a list of list using list comprehension

Ex:
Given: [ [1,2], [3,4], [5,6] ]
Expected: [[1, 3, 5], [2, 4, 6]]

Solution:

a = [ [1,2], [3,4], [5,6] ]
final_list = [[x[0] for x in a], [x[1] for x in a]]
print(final_list)

[SQL] Find N'th largest record without LIMIT

Muthu — Mon, 31 May 2021 22:04:29 +0000

SELECT * 
FROM employee_info e1
WHERE N-1 = 
   (
      SELECT COUNT(DISTINCT salary)
      FROM employee_info e2
      WHERE e1.salary < e2.salary
    )

[SQL] Find third largest record from a table

Muthu — Mon, 31 May 2021 21:59:44 +0000

Query to find third largest salary record from employee table

SELECT * 
FROM employee_info
ORDER BY salary
LIMIT 2, 1

[PYTHON] Quick way to copy a JSON element

Muthu — Tue, 07 Jul 2020 20:40:34 +0000

Facing some problem in using the JSON from previous functions?
Lets try this!

import copy
# the template json holds the basic info
json_template = {'id':1, 'todo': 'Wake-up'}

# copy the template json and build the new json on top of it
todo_json = copy.deepcopy(json_template)
todo_json['id'] = 7726

Be Lazy - 01

Muthu — Thu, 13 Feb 2020 21:55:55 +0000

Software Development is an Art more than the Science

Steps to auto Firebase deployment using GITHUB Actions (CI/CD)

Muthu — Mon, 20 Jan 2020 22:27:17 +0000

Step #1

Create a GITHUB repository

Step #2

Create a Firebase Project on the Firebase console

Step #3

$ firebase init

And choose your project and select Hosting from the CLI tool

Step #4

Create package.json using

$ npm init

Once the package.json created add the following component on the JSON under scripts

"build:production": "node --version",
"build:prod": "node --version",

The final package.json will look like this

package.json

{
  "name": "cicd",
  "version": "1.0.0",
  "description": "",
  "main": "index.js",
  "scripts": {
    "build:production": "node --version",
    "build:prod": "node --version",
    "test": "echo \"Error: no test specified\" && exit 1"
  },
  "repository": {
    "type": "git",
    "url": "git+https://github.com/muthugit/cicd.git"
  },
  "author": "",
  "license": "ISC",
  "bugs": {
    "url": "https://github.com/muthugit/cicd/issues"
  },
  "homepage": "https://github.com/muthugit/cicd#readme"
}

Step #5

Create the workflow file (main.yml) on the following directory

$ <root directory>/.github/workflows

main.yml

name: FIREBASE-DEPLOY

on:
  push:
    branches:
    - master
    - release/*


jobs:
  firebase-deploy:


    runs-on: ubuntu-latest


    steps:
    - uses: actions/checkout@master
    - uses: actions/setup-node@master
      with:
        node-version: '10.x'
    - run: npm install
    - run: npm run build:prod
    - uses: w9jds/firebase-action@master
      with:
        args: deploy --only hosting
      env:

        FIREBASE_TOKEN: ${{ secrets.FIREBASE_TOKEN }}

Step #6

Get the Firebase token by running this

$ firebase login:ci

Step #7

Goto GITHUB.com and navigate to your repository
Goto Settings -> Secrets
Create new secret
Copy the secret generated on the previous step and name the secret as FIREBASE_TOKEN

Step #8

Thats it! Just push your code. This will deploy the PUBLIC folder to firebase hosting

How do you find all pairs of an integer array whose sum is equal to a given number?

Muthu — Sat, 01 Jun 2019 21:56:56 +0000

input = [10,18,20,5,11,2,10,15]
sum = 20

length = len(input) 
for i in range(length): 
  for j in range(i+1, length):
    if(input[i] + input[j] == sum):
      print(input[i], input[j])

and the output is

10 10
18 2
5 15

How do you find the largest and smallest number in an unsorted integer array?

Muthu — Sat, 01 Jun 2019 21:41:14 +0000

Python is very simple language to do these kind of operations. Thats why its using in Machine Learning processes

input = [10,20,30,11,10]

print(max(input))
print(min(input))

And, the output is

30
10

How do you find the duplicate number on a given integer array?

Muthu — Sat, 01 Jun 2019 21:18:21 +0000

This five line code will sort-out the duplicate and non duplicate elements from the given list of number

input = [10,20,30,11,10]

duplicate_list, non_duplicate_list = [],[]
for el in input:
  duplicate_list.append(el) if(el in non_duplicate_list) else non_duplicate_list.append(el)

print(duplicate_list, non_duplicate_list)

and the output is

([10], [10, 20, 30, 11])

Thanks to https://simpleprogrammer.com/programming-interview-questions/ to post the question

Read Excel sheet using Pandas

Muthu — Mon, 27 May 2019 20:42:37 +0000

import pandas as pd

EXCEL_FILE = 'source.xlsx'

df= pd.read_excel(open(EXCEL_FILE, 'rb'),skiprows=3,index=False)

print(df)