Sandip B sandiprb

🏠

Working from home

Tech, Product, Design @pixeldust-in

sandiprb / useful_pandas_snippets.py

Created August 30, 2017 18:19 — forked from bsweger/useful_pandas_snippets.md

Useful Pandas Snippets

	# List unique values in a DataFrame column
	pd.unique(df.column_name.ravel())

	# Convert Series datatype to numeric, getting rid of any non-numeric values
	df['col'] = df['col'].astype(str).convert_objects(convert_numeric=True)

	# Grab DataFrame rows where column has certain values
	valuelist = ['value1', 'value2', 'value3']
	df = df[df.column.isin(valuelist)]

sandiprb / vs-code.settings.json

Last active May 9, 2018 09:12

	{
	"workbench.colorTheme": "Material Theme Palenight",
	"window.zoomLevel": -1,
	"editor.insertSpaces": true,
	"editor.wordWrap": "on",
	"workbench.sideBar.location": "right",
	"editor.fontSize": 15,
	"files.exclude": {
	"**/.git": true,
	"**/.svn": true,

sandiprb / employeeLeavesReader.js

Last active September 28, 2018 08:07

	const fs = require('fs');
	const util = require('util');

	const readFile = util.promisify(fs.readFile);

	async function getFileLines() {
	try {
	const args = process.argv.slice(2)
	if (!args.length) {
	console.warn('>> Please pass file name as argument <<')

sandiprb / .postcssrc.js

Created October 26, 2018 13:23

postcss rc for vue js

	const path = require('path')

	module.exports = {
	plugins: {
	"postcss-import": {
	resolve(id, basedir) {
	// resolve alias @css, @import '@css/style.css'
	// because @css/ has 5 chars
	if (/^@css/.test(id)) {
	return path.resolve('./src/assets/css', id.slice(5))

sandiprb / .prettierrc

Created October 27, 2018 07:14

sandiprb / slugify.js

Created November 13, 2018 20:07 — forked from mathewbyrne/slugify.js

Javascript Slugify

	function slugify(text)
	{
	return text.toString().toLowerCase()
	.replace(/\s+/g, '-') // Replace spaces with -
	.replace(/[^\w\-]+/g, '') // Remove all non-word chars
	.replace(/\-\-+/g, '-') // Replace multiple - with single -
	.replace(/^-+/, '') // Trim - from start of text
	.replace(/-+$/, ''); // Trim - from end of text
	}

sandiprb / googlesheets-to.json.js

Created May 28, 2020 12:16

Node JS script to fetch Google Sheets data as json

	const { GoogleSpreadsheet } = require('google-spreadsheet');
	const fs = require('fs');

	const JSON_FILE_NAME = 'data.json'
	const FILE_PATH = `/data/${JSON_FILE_NAME}`
	const GOOGLE_SHEET_ID = ''

	/* Create google credentials and save the credentials json file */
	const creds = require('./credentials.json')

sandiprb / admin.py

Last active June 6, 2020 13:54

Django admin register all models of an app dynamically

	from django.contrib import admin
	from django.apps import apps
	from django.contrib.auth.admin import UserAdmin as DjUserAdmin
	from . import models

	# Register your models here.
	@admin.register(models.User)
	class UserAdmin(DjUserAdmin):
	pass

sandiprb / Dockerfile

Created June 17, 2020 20:29

Deploy React / Vue / Front-end node projects with nginx Docker image

	# Use a lighter version of Node as a parent image
	FROM node:10 as project-build

	# Set the working directory to /frontend
	WORKDIR /project

	COPY package*.json /project/

	RUN npm install

sandiprb / 📊 Weekly development breakdown

Last active October 29, 2020 01:09

Weekly Development Breakdown