Giter VIP home page Giter VIP logo

Carolyn_Massa_Data_Analysis's Projects

automatewithpython icon automatewithpython

If you've ever spent hours renaming files or updating hundreds of spreadsheet cells, you know how tedious tasks like these can be. But what if you could have your computer do them for you? In Automate the Boring Stuff with Python, you'll learn how to use Python to write programs that do in minutes what would take you hours to do by hand-no prior programming experience required. Once you've mastered the basics of programming, you'll create Python programs that effortlessly perform useful and impressive feats of automation to: Search for text in a file or across multiple files Create, update, move, and rename files and folders Search the Web and download online content Update and format data in Excel spreadsheets of any size Split, merge, watermark, and encrypt PDFs Send reminder emails and text notifications Fill out online forms

clustering icon clustering

K Means Clustering , DBSCAN. ALGOMERATIVE, Spectral clustering

facilitysql icon facilitysql

This is the SQL Mini Project: The data you need is in the "country_club" database. This database contains 3 tables: i) the "Bookings" table, ii) the "Facilities" table, and iii) the "Members" table.

jsonbworldbankproject icon jsonbworldbankproject

Find the 10 countries with the most projects. Find the top 10 major project themes (using column mjtheme_namecode). For some entries in the exercise above, the name is missing. Create a dataframe filling in the missing names. Import Packages, Load JSON file as a Dataframe, Inspect - Get a look at the state and structure of the dataset. Inspect the columns needed for the exercises. Find the 10 Countries with the Most Projects - Retrieve a value count of country names, which is sorted in descending order; save the first 10 results. Load JSON file as a String, Flatten, Inspect - The column needed to finish the exercises contains nested data, so it needs to be normalized. Find the Top 10 Major Project Themes - This is accomplished by a value count of project codes since names are known to be missing. Create a Dataframe Filling in the Missing Names - Sort the dataframe, fill empty cells with NULL values, then replace those by backfilling. Find the Top 10 Major Project Themes by Theme Name - Produce a more descriptive list of top projects by getting a value count of project names.

spark icon spark

Coding Exercise performed in DataBricks

supplychainpy icon supplychainpy

Supplychainpy is a Python library for supply chain analysis, modelling and simulation. The library assists a workflow that is reliant on Excel and VBA.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.