Using Python to process experimental data-yechen_pro_20171231

Holistic approach 1. Observe the document structure:

-One of the working conditions

-Flow 128

-Measuring point position =0

-Measuring point profile depth-1

-The point data Speedxxxxxxxx.txt

-Measuring point profile depth-2

-Measuring point profile depth-3

-...

-Measuring point position =0.625d

-Measuring point position =1.75d

-...

-Flow 148

-Measuring point position =0

-...

-Two of the working conditions

-Flow 128

-Flow 148

-Three of the working conditions

-...

- ....

2. Observe the data structure:

Useful data is the data before the speed of the hop, and the amount of data is approximately 2000 rows.

3. Initial idea:

1. First read all subdirectories under the directory

2. Loop the subdirectory and traverse subdirectories under subdirectories, looping repeatedly until the root directory.

3. Data processing can be directly txt read, or imported into Excel, only valid data.

4. Perform a formula calculation of the data and export the final result to a new Excel.

Prepare knowledge

1. Directory and Documentation operations:

　　　　

　　　　

Using Python to process experimental data-yechen_pro_20171231