5/8/2023 0 Comments Convert xml to csv in r![]() ![]() Now you have stackexchange-xml-to-csv executable file. $ 7z e .7z -oxmlīadges.xml Comments.xml PostHistory.xml PostLinks.xml Posts.xml Tags.xml Users.xml Votes.xmlĬlone & build stackexchange-xml-to-csv converter: $ git clone -Votes.7z ( ~ 1.0G compressed / 20G uncompressed / 200M rows)Įxtract archive(s) content file(s) to the directory from where you will convert files using 7z or another archiver.Įxample with with .7z dump: $ mkdir xml csv.-Users.7z ( ~ 650M compressed / 4.0G uncompressed / 13M rows).-Tags.7z ( ~ 900K compressed / 5.0M uncompressed / 60K rows).-Posts.7z ( ~ 16G compressed / 80G uncompressed / 50M rows).-PostLinks.7z ( ~ 100M compressed / 800M uncompressed / 7M rows).-PostHistory.7z ( ~ 28.0G compressed / 138G uncompressed / 133M rows).-Comments.7z ( ~ 4.5G compressed / 22G uncompressed / 76M rows ).-Badges.7z ( ~ 70M compressed / 4G uncompressed / 37M rows ).Important: Stackoverflow dump stored in 8 separated 7z archives: Possible candidate is 7z.Ĭhoose and download the database dump that you are going to convert. It should display the current version of the compiler. Execute in the console go version command. ![]() ![]() Working Go environment with go version >= 1.14.CLI tool that allows you to convert Stack Exchange data dumps from XML to CSV format, which is more suitable for importing to the different databases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |