c3a24799c8
- Added all 89 albums that were genuinely dropped from 2020 to 2023 - Fixed incorrect status markings (many albums marked "New in 2023" were not new) - Removed duplicates and albums incorrectly marked as dropped - Final count: 589 total (500 main list + 89 dropped) - Updated JavaScript validation for extended range - Created comprehensive analysis scripts to verify data Math now adds up correctly: 89 albums dropped to make room for new additions 🤖 Generated with [Claude Code](https://claude.ai/code) Co-Authored-By: Claude <noreply@anthropic.com>
31 lines
No EOL
985 B
Python
31 lines
No EOL
985 B
Python
#!/usr/bin/env python3
|
|
"""
|
|
Create a simplified version of the 2020 CSV with only Rank, Artist, and Album columns.
|
|
"""
|
|
|
|
import csv
|
|
|
|
def main():
|
|
# Read the 2020 CSV and extract only needed columns
|
|
simplified_albums = []
|
|
|
|
with open('rolling_stone_top_500_albums_2020.csv', 'r', encoding='utf-8') as file:
|
|
reader = csv.DictReader(file)
|
|
for row in reader:
|
|
simplified_albums.append({
|
|
'Rank': row['Rank'],
|
|
'Artist': row['Artist'],
|
|
'Album': row['Album']
|
|
})
|
|
|
|
# Write simplified CSV
|
|
with open('rolling_stone_2020_simple.csv', 'w', newline='', encoding='utf-8') as file:
|
|
fieldnames = ['Rank', 'Artist', 'Album']
|
|
writer = csv.DictWriter(file, fieldnames=fieldnames)
|
|
writer.writeheader()
|
|
writer.writerows(simplified_albums)
|
|
|
|
print(f"✅ Created simplified 2020 CSV with {len(simplified_albums)} albums")
|
|
|
|
if __name__ == "__main__":
|
|
main() |