Powered by OpenAIRE graph
Found an issue? Give us feedback
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/ ZENODOarrow_drop_down
image/svg+xml art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos Open Access logo, converted into svg, designed by PLoS. This version with transparent background. http://commons.wikimedia.org/wiki/File:Open_Access_logo_PLoS_white.svg art designer at PLoS, modified by Wikipedia users Nina, Beao, JakobVoss, and AnonMoos http://www.plos.org/
ZENODO
Dataset . 2025
License: CC BY
Data sources: ZENODO
ZENODO
Dataset . 2025
License: CC BY
Data sources: Datacite
ZENODO
Dataset . 2025
License: CC BY
Data sources: Datacite
versions View all 2 versions
addClaim

Surface profiles of drilled and reamed holes

Authors: Kempten University of Applied Sciences; Institute for Data-Optimized Manufacturing (IDF); Jäkel, Thomas; Unsin, Sebastian; Müller, Benedikt; Schirmeier, Frank;

Surface profiles of drilled and reamed holes

Abstract

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 Included1. 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 pdimport matplotlib.pyplot as plt # Load the datasetdf = 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 borehole_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()

Keywords

Subtractive manufacturing, FOS: Mechanical engineering, Drilling, Metrology, Mechanical engineering, Reaming

  • BIP!
    Impact byBIP!
    selected citations
    These citations are derived from selected sources.
    This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    0
    popularity
    This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
    Average
    influence
    This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
    Average
    impulse
    This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
    Average
Powered by OpenAIRE graph
Found an issue? Give us feedback
selected citations
These citations are derived from selected sources.
This is an alternative to the "Influence" indicator, which also reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Citations provided by BIP!
popularity
This indicator reflects the "current" impact/attention (the "hype") of an article in the research community at large, based on the underlying citation network.
BIP!Popularity provided by BIP!
influence
This indicator reflects the overall/total impact of an article in the research community at large, based on the underlying citation network (diachronically).
BIP!Influence provided by BIP!
impulse
This indicator reflects the initial momentum of an article directly after its publication, based on the underlying citation network.
BIP!Impulse provided by BIP!
0
Average
Average
Average