hoadu Goto Github PK

100-pandas-puzzles

100 data puzzles for pandas, ranging from short and simple to super tricky (60% complete)

analytics_vidhya

Codes related to activities on AV including articles, hackathons and discussions.

ancestry-us-immigration-srape

Python script takes a specified CSV of surnames and scrapes ancestry.com data from the database "New York, Passenger Lists, 1820-1957." Excel macro cleans the data, removing spaces, and unwanted HTML.

auto_bank_reconcilation

a python script to automate the dreaded bank reconciliation process by automatically highlighting any matching instances found in the user and the bank records.

autoofficer

My Practice For Liwanyun. He wants to count pages of thousands of words and excels and automatically to fill some word files.So I help him and practice my python skill.

bios8366

Advanced Statistical Computing at Vanderbilt University's Department of Biostatistics

blog-content

Content (ipython notebooks, pictures, etc.) from my blog.

brexcel

Converts excel to a python dict and vice-versa

cajamar-predictive-modelling-pycones16

cmd_dep_crm

xlwings-based mini CRM

content-audit

A Python script that extracts meta tags (keywords, description, title) from a provided list of URLs and dumps the results into an Excel spreadsheet.

crawl_ign

data-analysis-and-machine-learning-projects

Repository of teaching materials, code, and data for my data analysis and machine learning projects.

data-process

Handy scripts for processing stupid, ugly, anony data . Copy and Use it !

data_funicular

A lot of times at work I use a lot of excel sheets and generate graphs for test reports. I am limited to use Python's standard library only! (i.e I cannot install new packages, programs, etc). This is a solution to alleviate this pain

datacleaner

A Python tool that automatically cleans data sets and readies them for analysis.

datasciencepython

common data analysis and machine learning tasks using python

effective-pandas

Source code for my collection of articles on using pandas.

email-reminder

Verifies the excel for the given condition and notify via email.

emailautomationpython

Automating the weekly tracker by fetching data from excel online and sending mail through outlook, collating at the end of the week.

examples

Example files illustrating Python and Excel

excel-reports

Fetch SurveyMonkey results from Excel, analyse and plot.

excel2mysql-importer

This is a python application which extracts data from excel sheets and persists them in MySQL database. Can be used in situation when you need to persist large amount of data from several excel sheets into database within minutes.

excel_compare_tool

Python tool using OpenPyXl to compare Excel (xlsx) workbooks, worksheets and write differences to file

excel_scaper

A Python 2.7 script for parsing excel files and collecting google results

excelblackbox

Code for treating an Excel Spreadsheet as function which takes input and produces an ouput. The code requires that you have Excel installed on MS Windows machine with Python and the win32 library.

exporttoexcel

This is python function that in argument receives data, and that data export to Excel file!

generic_utils

Collection of small, heterogeneous and not necessarily maintained utilities

getweather

A python script to retrieve current weather and forecast data from openweathermap.org for your current position as well as any city arroudn the world. The Data can be loaded in a conky config file.

grubhub.com-scraping

A single-thread python program to scrape restaurant data on grubhub.com for specific city and export it to excel file.