Build a Memory-Earnings Comparison Sheet Without Mixing Units
Build a memory-earnings comparison sheet by keeping the reported value, currency, scale, reporting period, business scope and accounting basis in separate columns. Normalize millions and billions only within the same currency. Leave undisclosed values missing, and block comparisons whose definitions do not match. If two numbers look wildly different, first check the currency and the unit printed above the source table. The safe next step is to copy those labels alongside the original number—not to divide the larger number until it looks plausible. A unit conversion cannot repair a different fiscal period or turn company-wide sales into DRAM revenue. This is an English-language, beginner-friendly data-cleaning exercise, checked on October 21, 2026. The Python example runs locally without packages, credentials, web scraping or paid APIs. All amounts in the execution example are fictional; they are not Samsung, Micron or SK hynix results, and the output is not an investment ranking. ...