Data Analysis

From TeleCafeWiki
Revision as of 17:40, 28 October 2017 by Dave (Talk | contribs) (Data Analysis & Data Science Tools: Excel: Text Analysis using Excel)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Big Data

Good question; good answer.
A step by step process the author used to connect to a 24GB AWS instance via a laptop. Examples for Python and R users.

Business Intelligence

An exhaustive reference to problems seen in real-world data along with suggestions on how to resolve them.

BI Tools

A section from the Creative Commons book Getting the Most Out of Information Systems: A Manager's Guide.
These MySQL reporting tools fall into two broad camps – business intelligence suites where reporting is a major component, and tools that are specifically aimed at reporting. Also many of them are free.
Free Open Source Business Intelligence Solutions
Pentaho Community Edition, OpenText Actuate Information Hub, Free Edition, ReportServer, JasperReports Business Intelligence, Jedox Base, SpagoBI, ART, Pentaho Reporting, JMagallanes, OpenReports, Seal Report, Openi, NextReports, RapidMiner, Mondrian, KNIME.
Free Cloud Business Intelligence Solutions
Watson Analytics, SAP Lumira Cloud, Power BI, Microstrategy Analytics Express and Birst Express for NetSuite.
Free Proprietary Business Intelligence Solutions
EspressReport Lite, SAP Lumira, QlikView Personal Edition, InetSoft, Qlik Sense Desktop, icCube, Tableau Public.
Open Source Commercial Business Intelligence Solutions
Pentaho, Jaspersoft, Palo, Actuate Corporation, TACTIC.

Data Analysis & Data Science Tools

Datamaps.co is a free and simple platform for creating visualizations with data maps. It allows you to upload CSV file with region data, and fully customize your map's appearance. Your map chart can be saved as PNG or SVG. With datamaps.co, you can create a custom map of World, USA, China, Canada and more are coming.
Wrangler allows interactive transformation of messy, real-world data into the data tables analysis tools expect. Export data for use in Excel, R, Tableau, Protovis, ...
HTSQL is designed for data analysts and other accidental programmers who have complex business inquiries to solve and need a productive tool to write and share database queries. HTSQL is free and open source software.
Jigsaw is a visual analytics system to help analysts and researchers better explore, analyze, and make sense of such document collections.
Open Refine is a standalone open source desktop application for data cleanup and transformation to other formats, the activity known as data wrangling. It is similar to spreadsheet applications (and can work with spreadsheet file formats), however, it behaves more like a database.

Command Line

This hands-on guide demonstrates how the flexibility of the command line can help you become a more efficient and productive data scientist. You'll learn how to combine small, yet powerful, command-line tools to quickly obtain, scrub, explore, and model your data.
Tutorial inspired by Jeroen Janssens' book Data Science at the Command Line.

IDEs in the Browser | Cloud IDEs

Also See Python in Your Browser: Tools (below).

  • Cloud9 - Your development environment, in the cloud.
Cloud9 IDE is an online integrated development environment, published as open source from version 3.0. It supports hundreds of programming languages, including PHP, Ruby, Perl, Python, JavaScript with Node.js, and Go.
Code and Collaborate in the Cloud, for Free! No installation required. Create a new environment with our cloud IDE in seconds.
Further Reading
Compares "13 of the best Cloud IDEs," including the following (to name just a few): Akshell, Cloud9, Python Fiddle

D3

D3.js is a JavaScript library for manipulating documents based on data. D3 helps you bring data to life using HTML, SVG and CSS. D3’s emphasis on web standards gives you the full capabilities of modern browsers without tying yourself to a proprietary framework, combining powerful visualization components and a data-driven approach to DOM manipulation.

Excel

Text Analysis using Excel
FEATURES EXAMPLE WORKBOOK: Analysis of Literature and Medicine Courses.xlsm
The featured workbook looks interesting and appears quite comprehensive.
A quick guide to the types of analysis you can run, ranging from easy to hard.
EXAMPLE: Use this formula to count the number of words in a text string. =LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1
Approach, algorithm, VBA code and performance optimization of the Word Cloud with Excel implementation.
FEATURES: Split Text Tool (Microsoft Excel 2007-2013, 115K)
NOTE: If the Split Text Tool downloads as a Zip file, change the file extension from .zip to .xlsm.
FEATURES FOLLOWING DOWNLOADS:
- Word Clouds Bruce Springsteen (Microsoft Excel 2007-2013, 518.4K)
- Word Cloud Generic Template (Microsoft Excel 2007-2013, 78.7K)
- Word Cloud UDF (Microsoft Excel 2007-2013, 72.4K)
NOTE: If any of the tools downloads as a Zip file, change the file extension from .zip to .xlsm.

Python

Python is a very powerful programming language used for many different applications. Over time, the huge community around this open source language has created quite a few tools to efficiently work with Python. In recent years, a number of tools have been built specifically for data science. As a result, analyzing data with Python has never been easier.[1]

Python in Your Browser: Propaganda
Python 3 is great and you should use it. Here’s why...
Shows simple code examples running on Trinket.
Trinket can be used to post interactive Python code which your students can run in the browser or copy and paste for the purpose of running locally on their computer.
Python in Your Browser: Tools
Host, run, and code Python in the cloud!
The Python IDE for the web. Play around with and modify live example code. Share or demonstrate solutions to problems.
Powerful and simple online compiler, IDE, interpreter, and REPL. Write, run, save, and share code from your browser!
Skulpt is an entirely in-browser implementation of Python. No preprocessing, plugins, or server-side support required, just write Python and reload.
Python in the browser. No installation required.

Python & Spreadsheets

A python library to create, update and delete rows of data in a google spreadsheet.
  • XlsxWriter: Creating Excel files with Python and XlsxWriter
XlsxWriter is a Python module for creating Excel XLSX files.

Python Tips, Tutorials & Tricks

Python was originally a general purpose language. Over the years, with strong community support, dedicated libraries for data analysis and predictive modeling emerged.
Step-by-step instructions for setting up an environment to scan hidden services in the dark web!

Web Scraping With Python

Scrapy is an open source and collaborative framework for extracting the data you need from websites. In a fast, simple, yet extensible way.

R

R Studio

Take control of your R code. RStudio is the premier integrated development environment for R. It is available in open source and commercial editions and runs on the desktop (Windows, Mac, and Linux) or over the web with RStudio Server. Download RStudio (for Windows, Mac, or Linux).

R & Excel

In quantitative finance both R and Excel are the basis tools for any type of analysis. Whenever one has to use Excel in conjunction with R, there are many ways to approach the problem and many solutions. It depends on what you really want to do and the size of the dataset you’re dealing with.
Simplifies the creation of Excel .xlsx files by providing a high level interface to writing, styling and editing worksheets. Through the use of Rcpp, read/write times are comparable to the xlsx and XLConnect packages with the added benefit of removing the dependency on Java.

R & Google Sheets

Interact with Google Sheets from R.
Access and manage Google spreadsheets from R with googlesheets.

Shiny

A web application framework for R.
- Turn your analyses into interactive web applications.
- No HTML, CSS, or JavaScript knowledge required.

Learn Data Science

Also See: Computer Productivity Hacks#Educate_Yourself

Academic credentials are important but not necessary for high-quality data science. The core aptitudes – curiosity, intellectual agility, statistical fluency, research stamina, scientific rigor, skeptical nature – that distinguish the best data scientists are widely distributed throughout the population.

We’re likely to see more uncredentialed, inexperienced individuals try their hands at data science, bootstrapping their skills on the open-source ecosystem and using the diversity of modeling tools available. Just as data-science platforms and tools are proliferating through the magic of open source, big data’s data-scientist pool will as well.

And there’s yet another trend that will alleviate any talent gap: the democratization of data science. Autodidacts – the self-taught, uncredentialed, data-passionate people – will come to play a significant role in many organizations’ data science initiatives.
 
Learn applied skills for a career in data science. Work with data, build projects, and gain experience. (No longer free.)
Analytics Vidhya | Dataaspirant | Dr. Randal S. Olson | Domino Data Lab's blog | Entrepreneurial Geekiness | no free hunch | Pythonic Perambulations | Rayli.Net | yhat | Beckerfuffle | Carl Shan | Data Mining: Text Mining, Visualization and Social Media | FastML | Garbled Notes | Joy Of Data | MLWave | Trevor Stephens | While My MCMC Gently Samples | Zac Stewart | Machined Learnings | Deep Learning | Nuit Blanche | Machine Learning (Theory) | Large Scale Machine Learning | Revolutions | KDnuggets | Wellecks | PyImageSearch | Data Mining Research | Trey Causey | Deep Learning | Machine Learning and Data Science | i am trask | Jonas Degrave | Yanir Seroussi | Life, Language, Learning | M.E.Driscoll | Models are illuminating and wrong | Christophe Bourguignat | samim | Andrej Karpathy blog | colah's blog | Sebastian Raschka | Edwin Chen | Simply Statistics | Will do stuff for stuff | Tombone's Computer Vision Blog | I’m a bandit | Data Science 101 | R-bloggers | Stitch Fix Tech Blog | DataGenetics | Dataquest Blog
The open-source curriculum for learning Data Science. Foundational in both theory and technologies, the OSDSM breaks down the core competencies necessary to make data useful.
The Internet is Your Oyster: With Coursera, ebooks, Stack Overflow, and GitHub -- all free and open -- how can you afford not to take advantage of an open source education?
Numerous "flash card"-style data science lessons.

Random Text, Number & String Generators

Tools
Free, GNU-licensed, random custom data generator for testing software.
Generate random lists, numbers, text strings, sequences and more.
Tutorials
Sometimes you may need to generate random strings, such as different passwords. This article tries to show you some tricks to generate different random strings in Excel.

Regular Expressions

In theoretical computer science and formal language theory, a regular expression (abbreviated regex or regexp and sometimes called a rational expression) is a sequence of characters that forms a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations.

Quick Tips

"The regex I use when I want to be precise is \r\n?|\n."

RegEx Tutorials

Includes:
- Interactive Tutorial › Learn to use Regular Expressions
- Practical Examples › Practice your Regular Expressions
- RegEx Cheatsheet › Regular Expressions in PHP & More
Any non-trivial regex looks daunting to anybody not familiar with them. But with just a bit of experience, you will soon be able to craft your own regular expressions like you have never done anything else.
Regex is the gift that keeps giving. Once you learn it, you discover it comes in handy in many places where you hadn't planned to use it.
This is an in-progress book that quickly teaches you regular expressions.

RegEx Tools

Regex101 allows you to create, debug, test and have your expressions explained for PHP, PCRE, JavaScript and Python. The website also features a community where you can share useful expressions.
Regular expression tester with syntax highlighting, contextual help, video tutorial, reference, and searchable community patterns.
Pythex is a real-time regular expression editor for Python, a quick way to test your regular expressions.
JavaScript regex tester. Highlights matches on the fly.

Small Data

Small Data is everything Big Data is not.

You Might Not Be Big Data If

- You were generated through human data entry. (Big Data came about in order to handle the exponential growth of machine-generated data, because we humans aren’t fast enough to outpace a good old relational database).
- You are an operational database. For instance, CRM is never Big Data, and ERP is never Big Data.
- You fit just fine in a MySQL database. Even if you have to put a lot of RAM in it, it’s still not Big Data.[2]

For the majority of small and medium businesses, Big Data is the technology of the future, not the reality they experience today. To be blunt, most SMBs don’t even have a handle on the Small Data they’re already creating and collecting themselves. (And if many enterprise organizations are being honest, neither do they.) According to Forrester Research, most companies are analyzing a mere 12% of their existing data. That leaves a whopping 88% of data that businesses are flat out ignoring. Can you imagine the potential of actually leveraging that existing data to derive data-driven business insights? Instead of chasing the Big Data dream, SMBs should consider picking up the dollars that are effectively lying on the floor, and invest first in leveraging their Small Data.
Just as we now find it ludicrous to talk of "big software" – as if size in itself were a measure of value – we should, and will one day, find it equally odd to talk of "big data". Size in itself doesn't matter – what matters is having the data, of whatever size, that helps us solve a problem or address the question we have.
What is small data, you ask? Small data is a dataset that contains very specific attributes. Small data is used to determine current states and conditions or may be generated by analyzing larger data sets.

SQL

Cheat Sheets

Simple-Talk's free wallchart of the most important SSMS keyboard shortcuts aims to help find all those curiously forgettable key combinations within SQL Server Management Studio that unlock the hidden magic that is available for editing and executing queries.

Fiddle with SQL in the Browser

I got this one to work. | Dave (talk) 18:01, 7 December 2016 (PST)
At Rextester you can not only compile PostgreSQL, but also several several other SQL flavors, too (SQL Server, MySQL, Oracle). Rextester also offers options for several other programming languages.

SQL & PowerShell

Scripting is very powerful. And for me, one of the best scripting languages is PowerShell (PoSH). Yes, PoSH takes a bit of getting used to, but once you pass the initial learning curve, you end up with a powerful tool in your hands.
Multiple examples; approaches.
Download the latest version of this PowerShell™ wallchart and read the accompanying in-depth article from Simple-Talk.
Also See:

Text Extraction

PDF Conversion

Capture2Text conceptual illustration.
Capture2Text conceptual illustration.
Capture2Text enables users to quickly OCR a portion of the screen using a keyboard shortcut. The resulting text will be saved to the clipboard by default.
Detexter is an app designed to extract text from PDF files.
I used this service to successfully convert the .US Locality Domain Name Registration Terms and Conditions form from PDF to Word format.
Lists several options.
Convert PDF to HTML without losing text or format.
Note: (Domain squatter has apparently hijacked the original pdftotext.org domain. But the service is still here: http://pdftotext.github.io/)
pdftotext.org is the best online service for easily extracting text from your PDF files. Conversion from PDF to TXT is really fast thanks to our in-browser conversion architecture. Your PDF files are never uploaded to the Internet, so even private PDF files are safe to convert with this service. The conversion is done locally in your browser – you can even convert when you are offline! There is no need for any registration or sign-up, and the service will always be free to use.
Extracts plain text from documents in all popular formats.
Tabula is a tool for liberating data tables locked inside PDF files. Tabula allows you to extract that data into a CSV or Microsoft Excel spreadsheet using a simple, easy-to-use interface. Tabula works on Mac, Windows and Linux.
Also See
Office Productivity Hacks#Portable Document Format (PDF)

Data Scrape ; Web Scrape

Tools and tips compiled by journalists from PBS and Omaha World-Herald.
Scrapinghub's list of open source scraping projects.
Monitor website links with ease. Sitestalker supervises websites and notifies you when your desired content hits the web.Stop wasting your time constantly refreshing websites.
Sitestalker is great for:
Finding jobs
Searching for an apartment
Getting the best bargains
Clipping
Tools for gathering data from public sources.
Web Scraping tools are specifically developed for extracting information from websites. They are also known as web harvesting tools or web data extraction tools. These tools are useful for anyone trying to collect some form of data from the Internet. Web Scraping is the new data entry technique that don’t require repetitive typing or copy-pasting.
R Scraper
Watch (video) how easy it is to import data from a Web page into R.

Text Search

Makes tools to search text content, including:
  1. FALCON - Text Search Java Project: JSON based text search Java Project
  2. HAWK - PDF Text Search Java Project: Taking initiative for Document Text Search
Xpdf is an open source viewer for Portable Document Format (PDF) files.
Windows installer: Short Programs/Scripts (Look for the xpdf3.exe / poppler.exe links in left sidebar.)

Text Transformation

Do you have a list of text strings that you want to modify the format on? Copy and paste the list into the a box, then provide an example of how you want each text string formatted. The hope is that Transformy will do the rest.

Workflow

Git, GitHub

Solution 1: A single repository can contain multiple independent branches, called orphan branches. Orphan branches are completely separate from each other; they do not share histories.
Solution 2: Avoid all the hassle of orphan branches. Create two independent repositories, and push them to the same remote. Just use different branch names for each repo.

#git, #github

See Also

References

  1. Introduction to Python for Data Science (edX)
  2. Forget Big Data–Small Data Is Where the Money Lies