Code Editor for app.py

import streamlit as st
from sqlalchemy import create_engine, Column, Integer, String, Float, Text
from sqlalchemy.orm import DeclarativeBase, Session
import pandas as pd

# Database setup
class Base(DeclarativeBase):
    pass

class UserProfile(Base):
    __tablename__ = 'user_profiles'
    
    id = Column(Integer, primary_key=True)
    name = Column(String(100))
    degree = Column(String(100))
    cgpa = Column(Float)
    interests = Column(Text)
    skills = Column(Text)

engine = create_engine('sqlite:///career_guide.db')
Base.metadata.create_all(bind=engine)

def get_career_recommendations(degree, cgpa, interests, skills):
    recommendations = []
    
    if 'tech' in interests.lower() or 'programming' in skills.lower():
        if cgpa >= 7.5:
            recommendations.extend(['Software Developer', 'Data Analyst'])
        else:
            recommendations.extend(['QA Engineer', 'Technical Support'])
    
    if 'business' in interests.lower() or 'communication' in skills.lower():
        recommendations.extend(['EdTech Sales', 'Business Analyst'])
        
    if 'cloud' in skills.lower():
        recommendations.append('Cloud Support Engineer')
        
    return recommendations[:3]  # Return top 3 recommendations

def generate_resume(name, degree, cgpa, skills, experience):
    resume = f"""
    {name}
    Education
    - {degree} | CGPA: {cgpa}
    
    Skills
    {skills}
    
    Professional Experience
    {experience}
    """
    return resume

st.set_page_config(page_title="Career Guide India", page_icon="🎓")

st.title("🎓 Career Guide for Tier-2 & Tier-3 Students")

tab1, tab2, tab3 = st.tabs(["Career Predictor", "Resume Builder", "Learning Paths"])

with tab1:
    st.header("Career Path Predictor")
    
    name = st.text_input("Full Name")
    degree = st.selectbox("Degree", ["B.Tech", "BCA", "MCA", "B.Sc", "M.Sc"])
    cgpa = st.slider("CGPA", 5.0, 10.0, 7.0, 0.1)
    interests = st.text_area("Interests (e.g., Technology, Business, Design)")
    skills = st.text_area("Skills (e.g., Python, Cloud, Communication)")
    
    if st.button("Get Career Recommendations"):
        recommendations = get_career_recommendations(degree, cgpa, interests, skills)
        
        # Save to database
        with Session(engine) as session:
            profile = UserProfile(
                name=name,
                degree=degree,
                cgpa=cgpa,
                interests=interests,
                skills=skills
            )
            session.add(profile)
            session.commit()
        
        st.subheader("Recommended Career Paths:")
        for i, rec in enumerate(recommendations, 1):
            st.write(f"{i}. {rec}")

with tab2:
    st.header("Resume Builder")
    
    name = st.text_input("Full Name", key="resume_name")
    degree = st.selectbox("Degree", ["B.Tech", "BCA", "MCA", "B.Sc", "M.Sc"], key="resume_degree")
    cgpa = st.number_input("CGPA", 5.0, 10.0, 7.0)
    skills = st.text_area("Skills (comma separated)")
    experience = st.text_area("Professional Experience/Projects")
    
    if st.button("Generate Resume"):
        resume = generate_resume(name, degree, cgpa, skills, experience)
        st.text_area("Generated Resume", resume, height=400)
        st.download_button(
            "Download Resume",
            resume,
            file_name="resume.txt",
            mime="text/plain"
        )

with tab3:
    st.header("Learning Paths")
    
    role = st.selectbox("Select Role", [
        "Software Developer",
        "Data Analyst",
        "Cloud Engineer",
        "QA Engineer",
        "Sales Engineer"
    ])
    
    if role == "Software Developer":
        st.write("Recommended Learning Path:")
        st.markdown("""
        1. Programming Fundamentals
           - [Python Basic to Advanced (YouTube)](https://youtube.com)
           - [DSA Course (NPTEL)](https://nptel.ac.in)
        
        2. Web Development
           - [Full Stack Development (freeCodeCamp)](https://freecodecamp.org)
           
        3. Version Control
           - [Git & GitHub (YouTube)](https://youtube.com)
        """)
    
    elif role == "Data Analyst":
        st.write("Recommended Learning Path:")
        st.markdown("""
        1. Python for Data Analysis
           - [Pandas Tutorial (YouTube)](https://youtube.com)
           
        2. SQL Fundamentals
           - [SQL Course (W3Schools)](https://w3schools.com)
           
        3. Data Visualization
           - [Tableau Fundamentals (YouTube)](https://youtube.com)
        """)

st.sidebar.title("📌 Quick Links")
st.sidebar.markdown("""
- 📝 Interview Prep
- 💼 Job Alerts
- 📚 Free Resources
""")

# Newsletter Signup
st.sidebar.markdown("---")
st.sidebar.header("📬 Newsletter Signup")
email = st.sidebar.text_input("Email")
if st.sidebar.button("Subscribe"):
    st.sidebar.success("Thanks for subscribing!")

# Premium Features Teaser
st.sidebar.markdown("---")
st.sidebar.header("🌟 Premium Features")
st.sidebar.markdown("""
- Full Mock Interview Sets
- Personalized Feedback
- Resume Review
- 1:1 Mentoring
""")