{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[],"authorship_tag":"ABX9TyPijnmTQ8dfg1ilf5IbzsKT"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"code","execution_count":null,"metadata":{"id":"anSlmMC_SjKt"},"outputs":[],"source":["import pandas as pd\n","from google.colab import drive\n","from google.colab import files\n","\n","# Upload your CSV files manually or use the following command to upload from your local machine\n","uploaded = files.upload()\n","\n","# Load the uploaded CSV files into DataFrames\n","df1 = pd.read_csv('file1.csv')\n","df2 = pd.read_csv('file2.csv')\n","\n","\n","# Combine the DataFrames (assuming they have the same structure)\n","combined_df = pd.concat([df1, df2], ignore_index=True)\n","\n","# Display the combined DataFrame\n","print(combined_df.head())\n","\n","# Mount Google Drive\n","drive.mount('/content/drive')\n","\n","# Specify the destination path in Google Drive\n","destination_path = '/content/drive/My Drive/combined_data.csv'\n","\n","# Save the combined DataFrame to a CSV file in Google Drive\n","combined_df.to_csv(destination_path, index=False)\n","\n","print(f'The combined data has been saved to: {destination_path}')\n","\n","# Provide instructions for sharing the file\n","print(\"The file has been saved to your Google Drive. To share the file:\")\n","print(\"1. Open Google Drive in your web browser.\")\n","print(\"2. Locate the 'combined_data.csv' file in 'My Drive'.\")\n","print(\"3. Right-click on the file and select 'Share'.\")\n","print(\"4. Add specific people or change the link settings to share the file.\")\n"]}]}