Surface profiles of drilled and reamed holes

This dataset includes surface profiles—raw profile, roughness, and waviness—of 3,600 reamed holes and 400 drilled holes. Additionally, it features a 360-degree scan of a reamed bore captured at five-degree increments. It is part of the project "KI-Span". The research project focuses on improving tool life and part quality in machining processes by analysing data, with the goal of developing robust, process-independent methods. By leveraging high-quality production data, the project aims to reduce tool-related costs, particularly in industries like aerospace, where tools account for a significant portion of production expenses.

Files Included
1. Reamed_hole_360.parquet

• Description: Contains surface data of a single bore, measured in 1° increments.
• Index: distance — the distance along the bore axis.
• Columns: multi-level: 1. 'raw_profile' or 'roughness'; 2. Measurement taken at a specific angular position 0-359 (in degrees).
• Values: Height data of the profiles.

2. surface_profiles.parquet

• Description: Contains raw surface profiles, waviness, and roughness data of all measured bores.
• Index: A multi-level index with 1. 'plate', 2. 'hole_number' and 3. 'distance'.
• Columns: 'raw_profile', 'waviness' and 'roughness'.
• Values: Height data of the profiles.

Example Usage in Python

import pandas as pd
import matplotlib.pyplot as plt

# Load the dataset
df = pd.read_parquet(".../surface_profiles.parquet", engine="pyarrow")

# Exclude drilled holes (not reamed)
drilled_rows = [3, 10, 17]
max_hole_number = df.index.get_level_values('hole_number').max()
drilled_holes = [i for i in range(1, max_hole_number + 1) if i % 20 in drilled_rows]
df = df[~df.index.get_level_values('hole_number').isin(drilled_holes)]

# Plot the raw profile of one bore
hole_data = df.loc[(2, 11)]  # (plate 2, hole 11)

plt.figure(figsize=(10, 2))
plt.plot(hole_data.index, hole_data['raw_profile'], label='Raw Profile')

plt.xlabel('Distance (mm)')
plt.ylabel('Raw Profile (mm)')
plt.title('Raw Profile of Hole 11 (Plate 1)')
plt.grid(True)
plt.legend()
plt.tight_layout()
plt.show()