Skip to content

Instantly share code, notes, and snippets.

View dewanshrawat15's full-sized avatar
💻
Building Thoughts, Taption, Jack, Cuisinier, Promptia and Alfred

Dewansh Rawat dewanshrawat15

💻
Building Thoughts, Taption, Jack, Cuisinier, Promptia and Alfred
View GitHub Profile
PassengerId Pclass Name Sex Age SibSp Parch Ticket Fare Cabin Embarked
892 3 Kelly, Mr. James male 34.5 0 0 330911 7.8292 Q
893 3 Wilkes, Mrs. James (Ellen Needs) female 47 1 0 363272 7 S
894 2 Myles, Mr. Thomas Francis male 62 0 0 240276 9.6875 Q
895 3 Wirz, Mr. Albert male 27 0 0 315154 8.6625 S
896 3 Hirvonen, Mrs. Alexander (Helga E Lindqvist) female 22 1 1 3101298 12.2875 S
897 3 Svensson, Mr. Johan Cervin male 14 0 0 7538 9.225 S
898 3 Connolly, Miss. Kate female 30 0 0 330972 7.6292 Q
899 2 Caldwell, Mr. Albert Francis male 26 1 1 248738 29 S
900 3 Abrahim, Mrs. Joseph (Sophie Halaut Easu) female 18 0 0 2657 7.2292 C
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 17 columns, instead of 7. in line 8.
Couple,Season,Location,Name,Age,Gender,Occupation,Decision,Status,DrPepperSchwartz,DrLoganLevkoff,DrJosephCilona,ChaplainGregEpstein,PastorCalvinRoberson,RachelDeAlto,DrJessicaGriffin,DrVivianaColes
1,1,New York City and Northern New Jersey,Jamie Otis-Hehner,27,F,Nurse,Yes,Married,1,1,1,1,0,0,0,0
1,1,New York City and Northern New Jersey,Doug Hehner,31,M,Software salesman,Yes,Married,1,1,1,1,0,0,0,0
2,1,New York City and Northern New Jersey,Cortney Hendrix,26,F,Make-up artist,Yes,Divorced,1,1,1,1,0,0,0,0
2,1,New York City and Northern New Jersey,Jason Carrion,27,M,Fireman,Yes,Divorced,1,1,1,1,0,0,0,0
3,1,New York City and Northern New Jersey,Monet Bell,33,F,Product development manager,No,Divorced,1,1,1,1,0,0,0,0
3,1,New York City and Northern New Jersey,Vaughn Copeland,30,M,Field service technician,No,Divorced,1,1,1,1,0,0,0,0
4,2,New York City and Northern New Jersey,Jaclyn Methuen,30,F,Vodka saleswoman,Yes,Divorced,1,1,1,1,0,0,0,0
4,2,New York City and Northern New Jersey,Ryan Ranellone,28,M,Real estate agen
import 'package:flutter/material.dart';
void main(){
runApp(
MaterialApp(
debugShowCheckedModeBanner: false,
home: HomeScreen(),
)
);
}

Downloader

Works as a basic downloader where you specify the link of the page from multiple files have to be downloaded. Using that page as reference, you specify the type of files that have to be downloaded (for example, pptx / mp3 / mp4). The downloader does the rest for you.

Index

  • README.md
  • main.py
  • requirements.txt
@dewanshrawat15
dewanshrawat15 / main.py
Created September 25, 2019 10:09
Python script to extract participant details for sorting different participants according to domain of interest.
import csv
names = []
emails = []
phoneNumbers = []
year = []
department = []
teamInterested = []
with open("data.csv", "r") as file:
row = csv.DictReader(file)
Just a normal script to truncate all numbers and special characters and allow only spaces and alphabets.
String url = "jdbc:mysql://localhost:3306/testdb?useSSL=false";
String user = "";
String password = "";
String author = "me";
String sql = "UPDATE table_name SET name = name1, email = email1, ...WHERE condition;";
try (Connection con = DriverManager.getConnection(url, user, password);
PreparedStatement pst = con.prepareStatement(sql)) {
@dewanshrawat15
dewanshrawat15 / GCloud.png
Last active June 11, 2019 07:29
Achievements
GCloud.png
@dewanshrawat15
dewanshrawat15 / Terminal Alarm
Last active June 11, 2019 07:21
A terminal alarm python script. It is dependent on the playsound library. Plays all songs in the directory until you're awake.
import time
from playsound import playsound
import os
from os import system
filename = os.listdir()
songs = []
for file in filename:
if '.mp3' in file:
songs.append(file)