Skip to content

Instantly share code, notes, and snippets.

@korkridake

korkridake/glob_fileimport.py

Created November 23, 2018 07:13
Show Gist options
  • Save korkridake/67d436d8f3dde6e646c02e70aff58568 to your computer and use it in GitHub Desktop.
Save korkridake/67d436d8f3dde6e646c02e70aff58568 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
glob_fileimport.py
# ---------------------------------------------------------------
# basic libraries
# ---------------------------------------------------------------
import pandas as pd
import numpy as np
from glob import glob
import warnings
warnings.filterwarnings('ignore')
# ---------------------------------------------------------------
# read the files
# ---------------------------------------------------------------
mylst = sorted(glob('[File Path]'))
mydf = pd.concat((pd.read_csv(f, delimiter='|', thousands = ",") for f in mylst), ignore_index=True)
mydf.shape
mydf.head()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment