Skip to main content
Code Review

Return to Answer

edited body
Source Link
Eric Duminil
Eric Duminil
  • 4k
  • 1
  • 19
  • 27

Let me tell you about IMPORTHTML()...

enter image description here

So here's all the code you need in Google Sheets:

=IMPORTHTML("https://en.wikipedia.org/wiki/Transistor_count", "table", 12)

The import seems to work fine: enter image description here

And it's possible to download the table as CSV:

Processor,Transistor count,Date of introduction,Designer,MOS process,Area "MP944 (20-bit, *6-chip*)",,1970[14] (declassified 1998),Garrett AiResearch,, "Intel 4004 (4-bit, 16-pin)","2,250",1971,Intel,"10,000 nm",12 mm² "Intel 8008 (8-bit, 18-pin)","3,500",1972,Intel,"10,000 nm",14 mm² "NEC μCOM-4 (4-bit, 42-pin)","2,500[17][18]",1973,NEC,"7,500 nm[19]",*?* Toshiba TLCS-12 (12-bit),"over 11,000[20]",1973,Toshiba,"6,000 nm",32 mm² "Intel 4040 (4-bit, 16-pin)","3,000",1974,Intel,"10,000 nm",12 mm² "Motorola 6800 (8-bit, 40-pin)","4,100",1974,Motorola,"6,000 nm",16 mm² ... ...

You'll just need to clean the numbers up, which you'd have to do anyway with the API or by scraping with BeautifulSoup.

Let me tell you about IMPORTHTML()...

enter image description here

So here's all the code you need in Google Sheets:

=IMPORTHTML("https://en.wikipedia.org/wiki/Transistor_count", "table", 1)

The import seems to work fine: enter image description here

And it's possible to download the table as CSV:

Processor,Transistor count,Date of introduction,Designer,MOS process,Area "MP944 (20-bit, *6-chip*)",,1970[14] (declassified 1998),Garrett AiResearch,, "Intel 4004 (4-bit, 16-pin)","2,250",1971,Intel,"10,000 nm",12 mm² "Intel 8008 (8-bit, 18-pin)","3,500",1972,Intel,"10,000 nm",14 mm² "NEC μCOM-4 (4-bit, 42-pin)","2,500[17][18]",1973,NEC,"7,500 nm[19]",*?* Toshiba TLCS-12 (12-bit),"over 11,000[20]",1973,Toshiba,"6,000 nm",32 mm² "Intel 4040 (4-bit, 16-pin)","3,000",1974,Intel,"10,000 nm",12 mm² "Motorola 6800 (8-bit, 40-pin)","4,100",1974,Motorola,"6,000 nm",16 mm² ... ...

You'll just need to clean the numbers up, which you'd have to do anyway with the API or by scraping with BeautifulSoup.

Let me tell you about IMPORTHTML()...

enter image description here

So here's all the code you need in Google Sheets:

=IMPORTHTML("https://en.wikipedia.org/wiki/Transistor_count", "table", 2)

The import seems to work fine: enter image description here

And it's possible to download the table as CSV:

Processor,Transistor count,Date of introduction,Designer,MOS process,Area "MP944 (20-bit, *6-chip*)",,1970[14] (declassified 1998),Garrett AiResearch,, "Intel 4004 (4-bit, 16-pin)","2,250",1971,Intel,"10,000 nm",12 mm² "Intel 8008 (8-bit, 18-pin)","3,500",1972,Intel,"10,000 nm",14 mm² "NEC μCOM-4 (4-bit, 42-pin)","2,500[17][18]",1973,NEC,"7,500 nm[19]",*?* Toshiba TLCS-12 (12-bit),"over 11,000[20]",1973,Toshiba,"6,000 nm",32 mm² "Intel 4040 (4-bit, 16-pin)","3,000",1974,Intel,"10,000 nm",12 mm² "Motorola 6800 (8-bit, 40-pin)","4,100",1974,Motorola,"6,000 nm",16 mm² ... ...

You'll just need to clean the numbers up, which you'd have to do anyway with the API or by scraping with BeautifulSoup.

Source Link
Eric Duminil
Eric Duminil
  • 4k
  • 1
  • 19
  • 27

Let me tell you about IMPORTHTML()...

enter image description here

So here's all the code you need in Google Sheets:

=IMPORTHTML("https://en.wikipedia.org/wiki/Transistor_count", "table", 1)

The import seems to work fine: enter image description here

And it's possible to download the table as CSV:

Processor,Transistor count,Date of introduction,Designer,MOS process,Area "MP944 (20-bit, *6-chip*)",,1970[14] (declassified 1998),Garrett AiResearch,, "Intel 4004 (4-bit, 16-pin)","2,250",1971,Intel,"10,000 nm",12 mm² "Intel 8008 (8-bit, 18-pin)","3,500",1972,Intel,"10,000 nm",14 mm² "NEC μCOM-4 (4-bit, 42-pin)","2,500[17][18]",1973,NEC,"7,500 nm[19]",*?* Toshiba TLCS-12 (12-bit),"over 11,000[20]",1973,Toshiba,"6,000 nm",32 mm² "Intel 4040 (4-bit, 16-pin)","3,000",1974,Intel,"10,000 nm",12 mm² "Motorola 6800 (8-bit, 40-pin)","4,100",1974,Motorola,"6,000 nm",16 mm² ... ...

You'll just need to clean the numbers up, which you'd have to do anyway with the API or by scraping with BeautifulSoup.