15c4480db1
- Add agent configuration files (AGENTS.md, USER.md, IDENTITY.md, SOUL.md) - Add git configuration and skills management scripts - Add frontend/backend analysis tools and reports - Add DingTalk media sender utilities and documentation - Fix OpenClaw runtime environment (Node.js and Python) - Configure git remotes and push scripts
31 lines
1.0 KiB
Python
31 lines
1.0 KiB
Python
# -*- coding: utf-8 -*-
|
|
"""Create test Excel file with pandas"""
|
|
|
|
import pandas as pd
|
|
|
|
# Create test data
|
|
data = {
|
|
'Repository': ['openclaw/openclaw', 'github/copilot', 'nodejs/node', 'microsoft/vscode'],
|
|
'URL': ['https://github.com/openclaw/openclaw', 'https://github.com/github/copilot', 'https://github.com/nodejs/node', 'https://github.com/microsoft/vscode'],
|
|
'Stars': [1000, 5000, 90000, 150000],
|
|
'Language': ['TypeScript', 'JavaScript', 'JavaScript', 'TypeScript'],
|
|
'Description': ['Multi-channel AI gateway', 'AI pair programmer', 'JavaScript runtime', 'Code editor']
|
|
}
|
|
|
|
# Create DataFrame
|
|
df = pd.DataFrame(data)
|
|
|
|
# Save to Excel
|
|
output_file = 'test_repo_data.xlsx'
|
|
df.to_excel(output_file, index=False, sheet_name='Repositories')
|
|
|
|
print(f"Created {output_file} with {len(df)} rows")
|
|
print("Columns:", list(df.columns))
|
|
print("\nFirst few rows:")
|
|
print(df.head())
|
|
|
|
# Also create a simple CSV for comparison
|
|
csv_file = 'test_repo_data.csv'
|
|
df.to_csv(csv_file, index=False)
|
|
print(f"\nAlso created {csv_file}")
|