web analytics
Skip to content
Monday, June 16, 2025

Zhuo Yao, Ph.D.

Professional Website of Dr. Zhuo Yao
Zhuo Yao, Ph.D.
Professional Website of Dr. Zhuo Yao
  • About Me
  • Teaching
  • Research
  • Hornors
  • Service
  • Publications
  • Demos
  • Resources
  • Tips
    • Writing
    • Research
    • Spatial Panel Modeling
    • SSH
    • Visual Studio 2010
    • Statistics
    • Technology
    • VB.Net
    • VISUM
    • Web design
    • R
    • Conference Papers
    • Journal papers published
    • Database
    • Legislation
    • Policy
    • Presentations
    • Publications
    • Working papers
    • Inforgraphics
    • ArcGIS
    • Career
    • Climate Change
    • Computer VIsion
    • Foundamentals
    • Geo-processing
    • Image Processing
    • MS Office
    • Travel Demand Modeling

Category: Python

Python

Extracting tabular data from a PDF: An example using Python and regular expressions

calsalmon February 3, 2015

It is not uncommon for us to need to extract text from a PDF. For small PDFs with minimal data or text it’s fairly straightforward…

View More Extracting tabular data from a PDF: An example using Python and regular expressions
Python

Import Data From Excel Into MySQL Using Python

calsalmon November 25, 2013

I just finished a basic Python script for a client that I’d like to share with you. He needed an easy means of moving data…

View More Import Data From Excel Into MySQL Using Python
Python

Filesystem structure of a Python project

calsalmon April 2, 2013

Do: name the directory something related to your project. For example, if your project is named “Twisted”, name the top-level directory for its source files Twisted.…

View More Filesystem structure of a Python project
Python

Manipulating Excel files using Python part 2: Writing Excel Files

calsalmon April 1, 2013

Writing Excel files using Python is quite easy, using the xlwt package. Similar to xlrd mentioned in an earlier post, xlwt allows one to write Excel files from scratch…

View More Manipulating Excel files using Python part 2: Writing Excel Files
Python

Manipulating Excel files using Python part 1: Reading Excel Files

calsalmon April 1, 2013

It is often the case that the freely available data online are in Excel format. If one has Excel, then one has the ability to…

View More Manipulating Excel files using Python part 1: Reading Excel Files
Python

Read Excel files from Python

calsalmon April 1, 2013

Use the excellent xlrd package, which works on any platform. That means you can read Excel files from Python in Linux! Example usage: Open the workbook import…

View More Read Excel files from Python
Python

Intro to Data Structures

calsalmon March 31, 2013

We’ll start with a quick, non-comprehensive overview of the fundamental data structures in pandas to get you started. The fundamental behavior about data types, indexing,…

View More Intro to Data Structures
Python

Computational tools

calsalmon March 31, 2013

Statistical functions Percent Change Both Series and DataFrame has a method pct_change to compute the percent change over a given number of periods (using fill_method to fill NA/null values). In [376]: ser =…

View More Computational tools
Python

Time Series / Date functionality

calsalmon March 31, 2013

pandas has proven very successful as a tool for working with time series data, especially in the financial data analysis space. With the 0.8 release,…

View More Time Series / Date functionality
Python

Reshaping and Pivot Tables

calsalmon March 31, 2013

Reshaping by pivoting DataFrame objects Data is often stored in CSV files or databases in so-called “stacked” or “record” format: In [1450]: df Out[1450]: date…

View More Reshaping and Pivot Tables

Posts pagination

Page 1 Page 2 Next page

  • Install WordPress with Apache and Let’s Encrypt SSL on Ubuntu 22.04
  • Notepad++ add to every line
  • RStudio Theme
  • Exercise 1: Multinomial logit model
  • Random utility model and the multinomial logit model
Zhuo Yao, Ph.D. | Designed by: Theme Freesia | WordPress | © Copyright All right reserved