File Input Output (CSV Excel JSON XML)¶

import pandas as pd

## CREATE SAMPLE CSV (Run this!)
sales_data = {
    'Month': ['Jan', 'Feb', 'Mar', 'Apr', 'May'],
    'Sales': [25000, 28000, 32000, 29000, 35000],
    'Costs': [18000, 20000, 22000, 19000, 23000]
}
df = pd.DataFrame(sales_data)
df.to_csv('sales_report.csv', index=False)
print("✅ CSV CREATED!")

## READ + ANALYZE (3 lines!)
df = pd.read_csv('sales_report.csv')
df['Profit'] = df['Sales'] * 0.28 - df['Costs']
print("📊 AUTOMATED CSV ANALYSIS:")
print(df)
print(f"💰 Total Profit: ${df['Profit'].sum():,.0f}")

📊 AUTOMATED CSV ANALYSIS:
  Month  Sales  Costs   Profit
0   Jan  25000  18000   5000.0
1   Feb  28000  20000   5840.0
...
💰 Total Profit: $21,760

## EXCEL → PYTHON IN 5 SECONDS
df = pd.read_excel('sales_report.xlsx')  # Replace CSV with Excel!

## ADD BUSINESS INTIGHTS
df['Margin'] = df['Profit'] / df['Sales'] * 100
df['Status'] = df['Profit'].apply(lambda p: '🎉' if p > 5000 else '⚠️')

## WRITE BACK TO EXCEL (Formatted!)
with pd.ExcelWriter('automated_profit_report.xlsx', engine='openpyxl') as writer:
    df.to_excel(writer, sheet_name='Profit_Analysis', index=False)

print("🏆 EXECUTIVE EXCEL REPORT CREATED!")
print(df)

import json

## API RESPONSE → PYTHON DATA
api_response = '''
{
    "company": "TechCorp",
    "quarterly_sales": [25000, 28000, 32000, 29000],
    "customers": {
        "vip": 25,
        "total": 150
    }
}
'''

## PARSE JSON (1 line!)
data = json.loads(api_response)

## BUSINESS ANALYSIS
sales = data['quarterly_sales']
total_sales = sum(sales)
vip_percentage = data['customers']['vip'] / data['customers']['total'] * 100

print("🌐 JSON API ANALYSIS:")
print(f"   Company: {data['company']}")
print(f"   Q1-Q4 Sales: ${total_sales:,.0f}")
print(f"   VIP %: {vip_percentage:.1f}%")

import xml.etree.ElementTree as ET

## LEGACY XML → MODERN ANALYSIS
xml_data = '''
<sales_report>
    <month name="Jan">25000</month>
    <month name="Feb">28000</month>
    <month name="Mar">32000</month>
</sales_report>
'''

root = ET.fromstring(xml_data)
sales = [int(month.text) for month in root.findall('month')]
total = sum(sales)

print("📜 XML LEGACY ANALYSIS:")
print(f"   Months: {[m.get('name') for m in root.findall('month')]}")
print(f"   Total Sales: ${total:,.0f}")
print("   ✅ LEGACY SYSTEM AUTOMATED!")

## UNIVERSAL READER (Pro trick!)
def read_any_file(filepath):
    if filepath.endswith('.csv'):
        return pd.read_csv(filepath)
    elif filepath.endswith('.xlsx'):
        return pd.read_excel(filepath)
    elif filepath.endswith('.json'):
        return pd.read_json(filepath)
    else:
        print("❌ Unsupported format!")
        return None

import pandas as pd
import json

## MISSION: Complete automation pipeline!

## 1. YOUR DATA
your_data = {
    'Month': ['???', '???', '???', '???'],
    'Sales': [???, ???, ???, ???],
    'Costs': [???, ???, ???, ???]
}

## 2. CREATE FILES
df = pd.DataFrame(your_data)
df.to_csv('my_business_data.csv', index=False)
df.to_excel('my_business_data.xlsx', index=False)

## 3. AUTOMATED ANALYSIS
df_read = pd.read_csv('my_business_data.csv')  # Read back!
df_read['Profit'] = df_read['Sales'] * 0.30 - df_read['Costs']

## 4. JSON EXPORT
json_data = {
    'summary': {
        'total_profit': float(df_read['Profit'].sum()),
        'best_month': df_read.loc[df_read['Profit'].idxmax(), 'Month']
    }
}
with open('business_summary.json', 'w') as f:
    json.dump(json_data, f, indent=2)

## 5. FINAL REPORT
print("🚀 YOUR AUTOMATION PIPELINE:")
print(df_read)
print(f"\n💎 JSON Summary created: {json_data}")
print("✅ FULL PIPELINE COMPLETE!")

your_data = {
    'Month': ['Jan', 'Feb', 'Mar', 'Apr'],
    'Sales': [25000, 28000, 32000, 29000],
    'Costs': [18000, 20000, 22000, 19000]
}

print("🎊" * 20)
print("FILE I/O = ENTIRE TEAMS REPLACED!")
print("💻 8-hour manual → 5-second automation!")
print("🚀 Companies pay $80K+ for THIS skill!")
print("🎊" * 20)