peeyush-es

import os
import glob
import pandas as pd

extension = 'csv'
all_filenames = [i for i in glob.glob('*.{}'.format(extension))]
combined_csv = pd.concat([pd.read_csv(f) for f in all_filenames ])
combined_csv.to_csv( "combined_csv.csv", index=False, encoding='utf-8-sig')

peeyush-es

cat /var/log/nginx/access.log | awk '$4 >= "[30/Nov/2020:15:00:00" && $4 < "[30/Nov/2020:15:01:00"' | awk '{print $7}' | sort -n | uniq -c | sort -nr | head -20