<jupyter_start><jupyter_text>Import libraries<jupyter_code>import bruges as br
import numpy as np
import pandas as pd
from welly import Well
import matplotlib.pyplot as plt<jupyter_output><empty_output><jupyter_text>Import wells<jupyter_code>R39 = Well.from_las('../data/R-39.las')
w129 = Well.from_las('../data/P-129_out.las')<jupyter_output><empty_output><jupyter_text>Make dataframes - Make dataframe- Select columns- Add well name column- Concatenate datafrmes<jupyter_code>w39_df = R39.df()
w39_df['DEPTH'] = w39_df.index
w39_df = w39_df[['DEPTH', 'DT4P', 'DT4S', 'RHOB']]
w39_df.columns = ['DEPTH','DT', 'DTS', 'RHOB']
name = (['R-39']*len(w39_df))
w39_df['well'] = name
w39_df = w39_df.reset_index(drop=True)
w39_df.describe(include = 'all')
w129_df = w129.df()
w129_df['DEPTH'] = w129_df.index
w129_df = w129_df[['DEPTH','DT', 'DTS', 'RHOB']]
name = (['P-129']*len(w129_df))
w129_df['well'] = name
w129_df = w129_df.reset_index(drop=True)
w129_df.describe(include = 'all')
wells = pd.DataFrame()

for i,df in enumerate([w129_df, w39_df]):
    wells=wells.append(df, ignore_index=True)
wells.describe()<jupyter_output><empty_output><jupyter_text>Convert to velocity  Import libraries<jupyter_code>MEGA_D1 = pd.DataFrame()

for i,df in enumerate([df0618, df1312, df01531, df0822, df0527, df0614, df1436, df021433, df0828]):
    MEGA_D1=MEGA_D1.append(df)<jupyter_output><empty_output>
{'fraction_non_alphanumeric': 0.16258992805755396, 'fraction_numerical': 0.08705035971223021, 'mean_word_length': 7.379518072289157, 'pattern_counts': {'":': 0, '<': 17, '<?xml version=': 0, '>': 17, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'chain_length': '4', 'dir': 'jupyter-structured-clean-dedup', 'id': '524248', 'license': 'Apache-2.0', 'n_tokens_mistral': 679, 'n_tokens_neox': 596, 'n_words': 100, 'path': 'notebooks_dev/Backus_from_dataframe_experiments.ipynb', 'repo_name': 'agile-geoscience/in-bruges', 'size': '1390'}