Month: January 2025

Posted on

ListShack *.csv import code

import os
import sqlite3
import pandas as pd

# Use the current folder where the script is located
folder_path = os.path.dirname(os.path.abspath(__file__))
database_path = os.path.join(folder_path, 'database.db')  # Database file in the same folder

# Connect to the SQLite database (or create it if it doesn't exist)
conn = sqlite3.connect(database_path)
cursor = conn.cursor()

# Function to import CSV to SQLite
def import_csv_to_sqlite(file_path, conn):
    # Extract table name from the file name (without extension)
    table_name = os.path.splitext(os.path.basename(file_path))[0]

    # Load CSV into a Pandas DataFrame
    try:
        df = pd.read_csv(file_path)
        # Write the DataFrame to SQLite
        df.to_sql(table_name, conn, if_exists='replace', index=False)
        print(f"Imported {table_name} successfully!")
    except Exception as e:
        print(f"Error importing {file_path}: {e}")

# Loop through all CSV files in the folder
for file_name in os.listdir(folder_path):
    if file_name.endswith('.csv'):
        file_path = os.path.join(folder_path, file_name)
        import_csv_to_sqlite(file_path, conn)

# Close the database connection
conn.close()
print(f"All CSV files in '{folder_path}' have been imported into the SQLite database: {database_path}")
Posted on

us states

Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
Illinois
Indiana
Iowa
Kansas
Kentucky
Louisiana
Maine
Maryland
Massachusetts
Michigan
Minnesota
Mississippi
Missouri
Montana
Nebraska
Nevada
New Hampshire
New Jersey
New Mexico
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
Rhode Island
South Carolina
South Dakota
Tennessee
Texas
Utah
Vermont
Virginia
Washington
West Virginia
Wisconsin
Wyoming

Posted on

~2034 06~

.

目標: “$100M” in FDIC insured CDs、

John1.5Generation.US

  • EA CPA M.Ed MFA MS PhDs MAcc MST MSW JD

2793 W 3rd Ave duplex,Cutler,Raven Landing

~”50年”、

1日、$0.62; 毎月$1,600 엄수

05:00AM~ McDonald’s Safeway 生活

  • 09:21AM GREEN, free to Costco ($1.50)

~2028 08/~2030 08 저축 while on SSDI

  • BookkeeperJohn.com for KAGRO 준비

2028 08~/2030 08~ UAF (stipend)

2034 06~2055 衣食住 해결

  • 307 W 5th Ave perpetual 확보
  • 2793 W 3rd Ave duplex BUILD
  • – 毎年”$3万” perpetual 저축

(9) UNH (stipend)

(9) Oregon State (stipend)

—

(9) MAcc

(9) MST MSW

(9) JD

—

.

Posted on

CPA-KAGRO.CsamiGroup.com

BookkeeperJohn.com

  • KAGRO Bookkeeping Service

{KAGRO}.CsamiGroup.com

  • KAGRO WooCommerce

1.5Generation(s).US

  • John.MyEAMyTAX.com
  • John.MyCPAMyTAX.com

{TAX SAT ACT CSAT}.JinuAcademy.com

CPA-KAGRO.CsamiGroup.com

  • EA CPA M.Ed MFA MS PhDs MAcc MST MSW JD

2793 W 3rd Ave duplex,Cutler,Raven Landing

Posted on

PATH

~2028 “$7万” 저축

~2034 06 UAF (stipend)

2055~ 毎年 “$3万” 저축

(9)

(9)

—

(9)

(9)

(9)

—

Posted on

毎9年 × 8번 (재)도전

目標: “$100M” in FDIC insured CDs、

~”$50年”、05:00AM~ McDonald’s Safeway 生活

  • 09:21AM GREEN, free to Costco ($1.50)
  • North Pole Branch Library

John1.5Generation.US

  • CPA-KAGRO.CsamiGroup.com

Roth IRA 毎年”$7,500″ (2028~55~2082)

(9) 2028~2037

Solo 401(k) 毎年”$6万” {2037}~2064

(9) 2037~2046

(9) 2046~2055

  • 2793 W 3rd Ave duplex BUILD
  • – 毎年”$3万” perpetual 저축

—

(9) UNH (stipend)

(9) Oregon State (stipend)

—

(9) 2073~2082

(9)

(9) Gonzaga / Willamette

—

Posted on

“IMPROMPTU”、Emergency

2025 06~2028 08($7万)/2030~2034 06

  • ~”50年”、05:00AM~ McDonald’s Safeway 生活
  • 2034 06~2055 衣食住 perpetual 해결 & “勝負”
  • 2793 W 3rd Ave duplex BUILD & 毎年$3万 저축
  • (9) 2055~2064 UNH (stipend)
  • (9) 2064~2073 Oregon State (stipend)
  • (9) 2091~2100 Gonzaga / Willamette
  • John1.5Generation.US (CPA-KAGRO.CsamiGroup.com)
  • – EA CPA M.Ed MFA MS PhDs MAcc MST MSW JD
  • – 2793 W 3rd Ave duplex,Cutler,Raven Landing

Alaska Mini Storage- Kutter

  • “Impromptu”、Hardware
  • – Google Pixelbook
  • – Samsung Galaxy
  • – Laptop / Scanner

Rescue Mission, Fairbanks, AK

Anchorage Gospel Rescue Mission

  • 1 hour flight from Fairbanks

Glory Hall, Juneau, AK

  • <2 hour flight from Anchorage

Cutler, UAF (Sr. Tuition Waiver)

Emergency Food Box

PO Box 56457 North Pole, AK 99705

800 E Dimond Blvd Ste 193-595 Anchorage, AK 99515

Posted on

CDs

$11M in FDIC insured CDs、”毎月 $2万”

<< Solo 401(k) {2037}~2064

~”50年”、05:00AM~ McDonald’s Safeway

2024 08~2028 저축 while on SSDI

  • R&D expenses、+ 毎月$1,150
  • >> “$7万” 저축

Roth IRA (2028~2055~2082)

(9) 2028~2037

  • 毎9年 (재)도전 “500개” × 8번
  • 2034 06~ 衣食住 perpetual 해결
  • – 307 W 5th Ave #10 & Safeway

Solo 401(k) {2037}~2064

(9) 2037~2046

  • 毎9年 (재)도전 “500개” × 7번 유지

(9) 2046~2055

  • 毎9年 (재)도전 “$100M” × 5번
  • 2793 W 3rd Ave duplex BUILD
  • – 소셜 시큐리티 70歳 수령
  • – Roth IRA into SPIA
  • – duplex 1 unit rental income
  • – 毎年 “$3万” perpetual 저축

—

(9) 2055~2064

(9) 2064~2073

—

(9) 2073~2082

(9) 2082~2091

(9) 2091~2100

—

John1.5Generation.US

CPA-KAGRO.CsamiGroup.com

  • EA CPA M.Ed MFA MS PhDs MAcc MST MSW JD

2793 W 3rd Ave duplex,Cutler,Raven Landing

Posted on

ListShack

CPAs w/ Website

  • {韓国人} CPA

Schools w/ Website

  • Mathematics Teachers

Groceries w/ Owner

  • KAGRO

Moving Companies