# LEGGI_python

**Repository Path**: VIT19980106/leggi_python

## Basic Information

- **Project Name**: LEGGI_python
- **Description**: homework
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-11-21
- **Last Updated**: 2024-11-21

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# LEGGI_python

#### 介绍
homework

#### Transport_extract.py

从杂乱的excel中提取数据集，并保存为csv，包括2019年到2022年
注意：2018年数据形式于19-20不一致

#### Transport_pre.py
1. Create a package and module
2. Open .csv and .xlsx files and create a DataFrame
3. Describe the dataframe
4. Change data types
5.Combine dataframes
6.Remove columns 
7. Deal with missing values
8. Columns with categorical values
9. Add new column
10. Save prepared data to .csv


2. Plotting distributions using histograms
3. ldentifying outliers using boxplots
4. Plotting timeseries
5. Chart styling

实现以上功能

![输入图片说明](image.png)

![输入图片说明](%E7%AE%B1%E7%BA%BF%E5%9B%BE%E5%BC%82%E5%B8%B8%E6%A3%80%E6%B5%8B.png)

![输入图片说明](%E6%97%B6%E9%97%B4%E5%BA%8F%E5%88%97.png)