krishnadey30 / leetcode-questions-companywise Goto Github PK

There are around 537 CSVs in the repo. I got a script to combine all the CSVs, but it was a huge mess, because the combined CSV file was 31 mb, and the formatting was all messed up. Basically, I wanted to create a CSV to order by the most frequently asked questions from all these companies.

import os
import glob
import pandas as pd
os.chdir('/mydir')

#find all csv files in the folder
#use glob pattern matching -> extension = 'csv'
#save result in list -> all_filenames
extension = 'csv'
all_filenames = [i for i in glob.glob('*.{}'.format(extension))]
#print(all_filenames)

#combine all files in the list
combined_csv = pd.concat([pd.read_csv(f) for f in all_filenames], axis=1)
#export to csv
combined_csv.to_csv( "aaaaa.csv", index=False, encoding='utf-8-sig')

The headings row should have values like question title, acceptance, difficulty, frequency, link

The CSV doesnt have headers, so lets take the below example

Guess the Word | 46.1% | Hard | 1.2138391004755573 | https://leetcode.com/problems/guess-the-word

what does 1.2138391004755573 stands for? If feasible could you please update the data ?

I am confused what this 1 year, 2 year, 6 months mean
Please add areadme or something that mentions the date and meaning of these terms

Hi, if possible can you update the latest company wise questions list

Are you still maintaining this repo? Currently studying for Google's interviews. Thanks!

Hey @krishnadey30 , Can you help me with the script to get this csv? I have 1 month leetcode premium and i can get this generated with the latest data and update the same repo !!

Thanks