list file and file size in a directory and export to .csv

file_size_df_to_csv.py

# import python modules
import os
import pandas as pd

# directory name from which
# we are going to extract our files with its size
path = "C:/Users/andre/Downloads/OneDrive_1_4-5-2022"

# Get list of all files only in the given directory
fun = lambda x: os.path.isfile(os.path.join(path, x))
files_list = filter(fun, os.listdir(path))

# Create a list of files in directory along with the size
size_of_file = [
    (f, os.stat(os.path.join(path, f)).st_size)
    for f in files_list
]

df = pd.DataFrame (size_of_file, columns = ['name','size in bytes'])
print (df)

df.to_csv (r'C:/Users/andre/Downloads/export_dataframe.csv', index = False, header=True)