web analytics
Skip to content
Saturday, September 06, 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

Author: construction supervison

Python

Read Excel files from Python

construction supervison 04/01/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
VB.Net

Office Development FAQ

construction supervison 04/01/2013

 Access • How do I export data from Access to an XML file? (VBA, VB 6) • How do I print an Access Report? (VB 6) • How do I…

View More Office Development FAQ
Python

Intro to Data Structures

construction supervison 03/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

construction supervison 03/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

construction supervison 03/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

construction supervison 03/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
Python

Group By: split-apply-combine

construction supervison 03/31/2013

By “group by” we are referring to a process involving one or more of the following steps Splitting the data into groups based on some criteria…

View More Group By: split-apply-combine
Python

IO Tools (Text, CSV, HDF5, …)

construction supervison 03/31/2013

CSV & Text files The two workhorse functions for reading text files (a.k.a. flat files) areread_csv() and read_table(). They both use the same parsing code to intelligently…

View More IO Tools (Text, CSV, HDF5, …)
Python

10 Minutes to Pandas

construction supervison 03/31/2013

This is a short introduction to pandas, geared mainly for new users. Customarily, we import as follows In [1]: import pandas as pd In [2]:…

View More 10 Minutes to Pandas
Python

Plotting with matplotlib

construction supervison 03/31/2013

Plotting with matplotlib Note We intend to build more plotting integration with matplotlib as time goes on. We use the standard convention for referencing the matplotlib API:…

View More Plotting with matplotlib

Posts pagination

Previous page Page 1 … Page 35 Page 36 Page 37 … Page 39 Next page
Zhuo Yao, Ph.D. | Designed by: Theme Freesia | WordPress | © Copyright All right reserved