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

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

“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

Posted on

~2028 08 R&D materials

CsamiGroup.com Inc. R&D 준비

毎年$15,000 저축 中、

Business Expenses (for R&D)

+ 月$1,150 (W-2 + K-1)

+ annual PFD

2034 06~ 의식주 perpetual 해결

  • 1日、$0.62; 毎月$1,600 엄수
  • 307 W 5th Ave #10 North Pole, AK 99705
  • – 05:00AM~ McDonald’s
  • – 09:21AM GREEN, free to Costco ($1.50)
  • – North Pole Branch Library (ILLiad)

Roth IRA 毎年 $7,500 (2028~2055~2082)

(9) 2028~2037

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

(9)

(9) 2046~2055

  • 2793 W 3rd Ave duplex BUILD
  • JINU (재)도전 毎9年 “$100M” × 5번
  • – 5万名 × 月$30 × 毎9年、”$100M”

—

(9)

(9)

—

(9)

(9)

(9)

—

John1.5Generation.US

  • EA CPA M.Ed MFA MS PhDs MAcc MST MSW JD
  • – CPA-KAGRO.CsamiGroup.com

2793 W 3rd Ave duplex,Cutler,Raven Landing

Posted on

2025~2028 08

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

“정신병 치료 및 요양 生活” 中、 “$7万” 저축

while on SSDI Medicaid EBT Cash Aid / annual PFD

Roth IRA 毎年 $7,500 (2028~2055~2082)

(9) 2028~2037

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

Mathematics MS, UAF (stipend) admission 준비

  • Mathematics MS, IndState (FAFSA)
  • M.Ed Credential, UAF admission 준비

Statistics. MS, UAF (stipend) admission 준비

  • Statistical Science MS, UIdaho (WRGP)
  • Special Education M.Ed, UAF admission 준비

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

(9) 2037~2046

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

BFA, UAF

Animation, UAF

(9) 2046~2055

MFA, UAF

CS BS, UAF

2793 W 3rd Ave duplex BUILD

  • Roth IRA (2028~2055) >> SPIA
  • 소셜 시큐리티 70歳 수령
  • duplex 1 unit rental income
  • – 毎年 $3万 perpetual 저축 확보

.

JINU (재)도전 毎9年 “$100M” × 5번

.

CsamiGroup.com Inc.

  • AK Allowable Absences (AB 540)
  • AK Residency (annual PFD)
  • AK S Corp.
  • BookkeeperJohn.com
  • {CPA}.CsamiGroup.com
  • 1.5Generation(s).US
  • MyEAMyTAX.com
  • MyCPAMyTAX.com / .org
  • JinuAcademy.com / .org
  • 1004site.com
  • abramjmeister.com

.

(9) UNH (stipend)

(9) Oregon State (stipend)

—

(9) MAcc

  • Paralegal Studies AAS, UAF
  • Social Work BA, UAF

(9) MST

  • Paralegal Studies AAS, UAF
  • MSW, UAA

(9) JD, Gonzaga / Willamette

  • Justice BA, UAF

—

John1.5Generation.US

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

2793 W 3rd Ave duplex,Cutler,Raven Landing

.

Posted on

~2028 08/2030

“$7万” 저축액

1.5Generation.US WordPress.com

Adobe Cloud

Alaska Mini Storage- Kutter

Alibris Books

BBA, EA QBO CPA

Booster for WooCommerce

Canva

Divi AI

Divi Marketplace

Gravity Forms

iPhone

Kindle Unlimited

LearnDash

ListShack

Manim

Namecheap VPS

Python

QBO@CsamiGrouo.com

R

School (Mathematics) Teachers Directory

TikZ

TurboTax

  • S Corp.
  • Individual

Woo Subscriptions

Yoast

중앙일보 Yellowpage

한국일보 업소록

  • 연변 TM ready

BookkeeperJohn.com

{CPA}.CsamiGroup.com

1.5Generation(s).US

MyEAMyTAX.com

MyCPAMyTAX.com / .org

JinuAcademy.com / .org

abramjmeister.com

1004site.com