GitHub Repository
VSCode-Python-2026
Python algorithms, SQL challenges, Terraform IaC, Crossplane/Kubernetes configs, PowerShell automation, and technical assessment solutions — all completed in 2026.
View on GitHub
$ git clone brianfilliat/VSCode-Python-2026
Technologies & Languages
🐍 Python 3
🗄️ MySQL / SQLite
⚙️ Terraform
☸️ Kubernetes / Crossplane
🔱 Ansible
🐚 Bash / Shell
💙 PowerShell
🪟 WSL2 / Docker
📊 Pandas / NumPy
🐙 ArgoCD / GitOps
📝 YAML / HCL
🔬 Data Science / ETL
Repository Structure brianfilliat/VSCode-Python-2026
VSCode-Python-2026/
├── array_algorithms_challenge.py
├── averageHeartBeat.py
├── counting_bits.py
├── getMaximumSubarray.py
├── list_operations_challenge.py
├── outlier_detection.py ← 🏆 100/100 Perfect Score
├── permutation_subarray_challenge.py
├── recursion_algorithms_challenge.py
├── solvePeaksProblem.py
├── string_algorithms_challenge.py
├── string_manipulation_challenge.py
├── README.md
├── DOCUMENTATION-INDEX.md
├── PYTHON-SCRIPTS-GUIDE.md
├── CodeCitations.md
│
├── MYSQL-DATA-2026/
│ ├── employee_salary_aggregations.sql
│ ├── travel_agency_trip_counter.sql
│ ├── customer_order_analysis.sql
│ ├── job_applicant_position_assignment.sql
│ ├── database_queries.py
│ ├── PYMySQLdatabase_queries.py
│ └── sqlite3-database-queries.py
│
├── CROSSPLANE/
│ ├── crossplane_overview.md
│ ├── runbook_ceph_partial_quorum.md
│ ├── interview_QA.md
│ ├── ansible/
│ ├── crossplane/gitops/ ← ArgoCD + GitHub Actions
│ └── scripts/setup_ansible_wsl.sh
│
├── terraform-project/
│ └── environments/ ← dev / stage / prod
│
├── POWERSHELL-Train-2026/
│ ├── README.md
│ ├── autovpn-debugging-session.md
│ └── troubleshooting-guide.md
│
├── WSL-WORK-2026/
│ ├── WSL-PATH-2026.txt
│ └── Docker Desktop WSL 2 backend.md
│
└── filliat-Assement-notes-2026/
├── ASSESSMENT-COMPLETE-DOCUMENTATION.md
├── Data-Engineer-BairesDev-2026.md
└── FISERV-Kubernetes-Container-Platform-Engineer-2026.md
Python Scripts 11 files
outlier_detection.py
320 lines · Python
FMCG Sales Data outlier detection and replacement using percentile-based approach. Score: 100/100 — Perfect.
array_algorithms_challenge.py
Python · Algorithms
Linear search, binary search, array reversal, max/min element, bubble sort, merge sort, and duplicate detection.
string_manipulation_challenge.py
270 lines · Python
Concatenation, slicing, case conversion, string methods, formatting, regex, and encoding operations.
string_algorithms_challenge.py
147 lines · Python
Palindrome check, anagram detection, vowel counting, longest common prefix, and string compression.
recursion_algorithms_challenge.py
124 lines · Python
Factorial, Fibonacci, recursive sum, power, GCD, flatten nested lists, and Tower of Hanoi.
list_operations_challenge.py
220 lines · Python
List creation, slicing, sorting, comprehensions, stacks, queues, nested lists, and functional operations.
getMaximumSubarray.py
52 lines · Python
Maximum subarray sum using Kadane's algorithm — classic dynamic programming interview problem.
permutation_subarray_challenge.py
54 lines · Python
Find maximum subarray length to remove from a permutation — position tracking with sliding window.
counting_bits.py
Python · Bit Manipulation
Count 1-bits in binary representation and return positions in ascending order — bit manipulation challenge.
solvePeaksProblem.py
25 lines · Python
Find maximum distance between peaks in an array — local maxima detection and distance calculation.
averageHeartBeat.py
Python · Data Processing
Heart rate data processing — average calculation and statistical analysis from sensor data streams.
Code Spotlight — outlier_detection.py 100/100 Score
outlier_detection.py — FMCG Sales Data Challenge
🏆 100 / 100
""" FMCG Sales Data - Outlier Detection and Replacement ==================================================== Challenge: Detect and replace outliers in sales revenue data Method: Percentile-based approach (1st and 99th percentiles) Score Achieved: 100/100 (Perfect Score!) Author: Brian Filliat | Repository: brianfilliat/VSCode-Python-2026 """ import pandas as pd import numpy as np def detect_and_replace_outliers(df, column): """Detect outliers using percentile method and replace with boundary values.""" p1 = df[column].quantile(0.01) # 1st percentile lower bound p99 = df[column].quantile(0.99) # 99th percentile upper bound outliers_low = (df[column] < p1).sum() outliers_high = (df[column] > p99).sum() df[column] = df[column].clip(lower=p1, upper=p99) return df, outliers_low, outliers_high, p1, p99 # Load and process data df = pd.read_csv('sales_data.csv') df_clean, low, high, p1, p99 = detect_and_replace_outliers(df, 'revenue') df_clean.to_csv('submission.csv', index=False) print(f"Outliers replaced: {low + high} | Bounds: [{p1:.2f}, {p99:.2f}]")
SQL Database Challenges MYSQL-DATA-2026/
employee_salary_aggregations.sql
SQL · Aggregations
SUM, MIN, MAX salary calculations grouped by department with HAVING clauses and window functions.
travel_agency_trip_counter.sql
SQL · Joins
Count trips between locations with alphabetical ordering using LEAST/GREATEST and self-joins.
customer_order_analysis.sql
SQL · Analysis
Total spending per customer with name formatting using CONCAT, GROUP BY, and ORDER BY.
job_applicant_position_assignment.sql
12K · SQL · CASE
Assign Senior/Intermediate/Junior levels based on qualifications using CASE WHEN logic and CTEs.
database_queries.py
Python · SQLite3
Python SQLite3 database operations — CRUD, parameterized queries, and result set processing.
PYMySQLdatabase_queries.py
Python · PyMySQL
PyMySQL connector for live MySQL database — connection pooling, parameterized queries, and error handling.
Crossplane & Kubernetes CROSSPLANE/
crossplane_overview.md
Markdown · Overview
Crossplane architecture overview — XRDs, Compositions, ProviderConfigs, and AWS provider setup.
runbook_ceph_partial_quorum.md
Markdown · Runbook
Production runbook for Ceph cluster partial quorum recovery — OSD failure, MON quorum, and remediation steps.
gitops-repo/
ArgoCD · GitHub Actions
GitOps repo with ArgoCD Application manifests, Crossplane Compositions for PostgreSQL, and CI/CD workflows.
setup_ansible_wsl.sh
Bash · Automation
Automated Ansible setup script for WSL2 environment — package installation, config, and inventory setup.
Technical Assessments filliat-Assement-notes-2026/
BairesDev
🏆 Perfect Score
Python Data Science Challenge — Outlier Detection
February 7, 2026
BairesDev
Data Engineer Coding Challenge
February 2026
FISERV
Kubernetes Container Platform Engineer
2026
Apple / Automation Engineer
Automation Engineer Assessment
2026
Honeywell
Technical Assessment — February 2026
February 10, 2026
TATA Consultancy
AWS Cloud Solution Architect Assessment
2026
PowerShell & WSL2 POWERSHELL-Train-2026/ · WSL-WORK-2026/
autovpn-debugging-session.md
17K · PowerShell · VPN
Full VPN auto-connect debugging session — PowerShell scripts, event logs, and remediation steps for Windows VPN.
troubleshooting-guide.md
14K · PowerShell
Comprehensive PowerShell troubleshooting guide — error handling, debugging techniques, and common fixes.
WSL-PATH-2026.txt
18K · WSL2 Config
WSL2 PATH configuration, environment setup, and integration notes for Windows/Linux interop in 2026.
screenfetch.sh
4.5K · Bash
System info display script — OS, kernel, CPU, RAM, and environment details for Linux/WSL2 terminals.