Data | Web

Shekhar

Biswas

  • Pivot Table in Python

    A pivot table is a data structure that helps to explore the relationships within a dataset. The pivot table takes simple columnwise data as input, and groups the entries into a two-dimensional table that helps to get summary of data. The difference between pivot tables and GroupBy can sometimes cause confusion, however, pivot tables can be considered as essentially a multidimensional version of GroupBy aggregation.

  • Hands on with NumPy

    Practice builds habits and good habits bring success. - SB NumPy is a Python library which stands for ‘Numerical Python’. It is the core module for scientific computing in Python. Although NumPy arrays are comparable to Python’s built-in list data type, NumPy arrays provide much more efficient storage and data operations as the size of arrays grow large. Efficient storage and manipulation of numerical arrays is absolutely fundamental to the process of doing data science. Therefore, all asp…

  • Python Workshop 4

    A smooth sea never made a skilled sailor. - John George Hermanson 1. In a small town in country Dreamland, the initial population is 1000 at the beginning of a year. The population regularly increases by 4 percent per year and recently the town has set up new industries. So,100 new inhabitants come for job or studies every year. The townhead wants an estimate that in how many years, the the town will get certain population based on varying 'percentage of population growth' and 'number …

  • Python Workshop 3

    In many ways, it's a dull language, borrowing solid old concepts from many other languages & styles: boring syntax, unsurprising semantics, few automatic coercions, etc etc. But that's one of the things I like about Python. - Tim Peters 1. You are given an array strarr of strings and an integer k. Your task is to return the first longest string consisting of k consecutive strings taken in the array. Example: longest_consec(["zone", "abigail", "theta", "form", "libe", "zas", "theta", "abig…

  • Python Workshop 2

    The harder you fall, the heavier your heart; the heavier your heart, the stronger you climb; the stronger you climb, the higher your pedestal. Criss Jami 1. Count the number of occurrences of each character and return it as a list of tuples in order of appearance. Example: ordered_count("abracadabra") == [('a', 5), ('b', 2), ('r', 2), ('c', 1), ('d', 1)] 2. Write a function that takes a string of braces, and determines if the order of the braces is valid. It should return true if the str…

  • Automation with R workshop 1

    I couldn't tell you in any detail how my computer works. I use it with a layer of automation. - Conrad Wolfram In the modern world of digitilization, companies are automating business processes at a rapid pace. Automation is making a hardware or software capable of doing things automatically without human intervention. However, 'without human assistance' does not mean it can decide what to do by itself. Rather, it works based on preset intstruction determined by some human being. Let's say M…

  • Python Workshop 1

    Code never lies, comments sometimes do. - Unknown Readers are requested to go thorugh Introduction to Python tutorial prior trying to solve the problems. 1. You are given an array (which will have a length of at least 3, but could be very large) containing integers. The array is either entirely comprised of odd integers or entirely comprised of even integers except for a single integer N. Write a method that takes the array as an argument and returns this "outlier" N. Sample test cases: [2, 4,…

  • Statistics Workshop (Beginner)

    27% of statistics are false. And 95% of jokes about statistics are stale. -Matyo History of Statistics dates back to the 9th century. Al-Kindi was the first mathematician who used statistics to decipher encrypted messages. He developed the first code-breaking algorithm in the House of Wisdom in Baghdad, based on frequency analysis. The Word 'statistics' originated from Latin word “Status” or the Italian word “Statista”, which meant "Political State”. 1602 - The word 'Statist' was used by Sh…

  • SQL Workshop 1

    "SQL, Lisp, and Haskell are the only programming languages that I've seen where one spends more time thinking than typing." - Philip Greenspun A brief history of SQL SQL which stands for “Structured Query Language” was developed by Raymond Boyce and Donald Chamberlin at IBM Research in the early 1970s. Initially, it was called SEQUEL (Structured English Query Language) but later the name was changed as UK-based Hawker Siddeley aircraft company claimed that name as a trademark. In his book …

  • Data science & AI: Basics of Machine Learning Algorithms

    "The core thing Google is working on is basically machine learning" - Eric Schmidt As we are moving forward with time, Artificial intelligence is shaping our future more powerfully than any other innovation. This transformational journey of computing which moved from large mainframes to PCs to cloud computaion is progressing in a rapid pace. But what makes it defining is not what has been done, but what is coming in our way in years to come. Anyone who is not aware of the practice and progress …