问:
Cannot install numpy for PyPy 3.8 on Win10
I am attempting to try out pypy, and I can install a few packages, but the important ones like Numpy and Pandas go boom!!!  I get similar issues if I try it within PyCharm.

see below.  Also at some point I also saw this error.

```
     Optimized (vendor) Blas libraries are not found.
      Falls back to netlib Blas library which has worse performance.
      A better performance should be easily gained by switching
      Blas library.

  Blas (http://www.netlib.org/blas/) libraries not found.
      Directories to search for the libraries can be specified in the
      numpy/distutils/site.cfg file (section [blas]) or by setting
      the BLAS environment variable.
```

```
pypy -m pip install --extra-index-url https://antocuni.github.io/pypy-wheels/manylinux2010 numpy

```
C:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64>pypy -m pip install --extra-index-url https://antocuni.github.io/pypy-wheels/manylinux2010 numpy
Looking in indexes: https://pypi.org/simple, https://antocuni.github.io/pypy-wheels/manylinux2010
warning: missing-index-doctype

The package index page being used does not have a proper HTML doctype declaration.

Problematic URL: https://antocuni.github.io/pypy-wheels/manylinux2010/numpy/

note: This is an issue with the page at the URL mentioned above.
hint: You might need to reach out to the owner of that package index, to get this fixed. See https://github.com/pypa/pip/issues/10825 for context.
Collecting numpy
  Using cached numpy-1.22.2.zip (11.4 MB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: numpy
  Building wheel for numpy (pyproject.toml) ... error
  error: subprocess-exited-with-error

  Building wheel for numpy (pyproject.toml) did not run successfully.
  exit code: 1

  [690 lines of output]
  Processing numpy/random\_bounded_integers.pxd.in
...
  Processing numpy/random\_sfc64.pyx
  Cythonizing sources
  WARN: Could not locate executable g77
  WARN: Could not locate executable f77
  WARN: Could not locate executable ifort
  WARN: Could not locate executable ifl
  WARN: Could not locate executable f90
  WARN: Could not locate executable DF
  WARN: Could not locate executable efl
  WARN: Could not locate executable gfortran
  WARN: Could not locate executable f95
  WARN: Could not locate executable g95
  WARN: Could not locate executable efort
  WARN: Could not locate executable efc
  WARN: Could not locate executable flang
  WARN: don't know how to compile Fortran code on platform 'nt'
  non-existing path in 'numpy\\distutils': 'site.cfg'
  running bdist_wheel
  running build
...
  creating build\src.win-amd64-3.8\numpy\core\src\multiarray
  BUILD_ARCHITECTURE: 'AMD64', os.name='nt', sys.platform='win32'
  non-existing path in 'numpy\\core': 'build\\src.win-amd64-3.8\\numpy\\core\\src\\common'
  creating build\src.win-amd64-3.8\numpy\core\src\common
...
  creating build\src.win-amd64-3.8\numpy\linalg
  ### Warning:  Using unoptimized lapack ###
  ### Warning:  Using unoptimized lapack ###
  running build_py
...
  creating C:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks
  WARN: CCompilerOpt.__init__[1169] : feature 'AVX512_KNL' is disabled, MSVC compiler doesn't support it
  WARN: CCompilerOpt.__init__[1169] : feature 'AVX512_KNM' is disabled, MSVC compiler doesn't support it
  WARN: CCompilerOpt.dist_test[590] : CCompilerOpt._dist_test_spawn[714] : Flags in command (C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /TcC:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\test_flags.c /FoC:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\test_flags.obj /arch:AVX512) aren't supported by the compiler, output ->
  cl : Command line warning D9002 : ignoring unknown option '/arch:AVX512'
  test_flags.c

  WARN: CCompilerOpt.cc_test_flags[1025] : testing failed
  WARN: CCompilerOpt.dist_test[590] : CCompilerOpt._dist_test_spawn[726] : Command (C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /TcC:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c /FoC:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.obj /arch:AVX2 /WX) failed with exit status 2 output ->
  cpu_avx512cd.c
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2065: '__m512i': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2146: syntax error: missing ';' before identifier 'a'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): warning C4013: '_mm512_lzcnt_epi32' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): warning C4013: '_mm512_loadu_si512' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2146: syntax error: missing ')' before identifier '__m512i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2059: syntax error: ')'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2297: '*': illegal, right operand has type 'char *'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2143: syntax error: missing ')' before ';'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(19): warning C4013: '_mm512_castsi512_si128' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(19): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(19): error C2440: 'function': cannot convert from 'int' to '__m128i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(19): warning C4024: '_mm_cvtsi128_si32': different types for formal and actual parameter 1

  WARN: CCompilerOpt.feature_test[1490] : testing failed
  WARN: CCompilerOpt.dist_test[590] : CCompilerOpt._dist_test_spawn[726] : Command (C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /TcC:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c /FoC:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.obj /arch:AVX2 /WX) failed with exit status 2 output ->
  cpu_avx512f.c
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2065: '__m512i': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2146: syntax error: missing ';' before identifier 'a'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): warning C4013: '_mm512_abs_epi32' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): warning C4013: '_mm512_loadu_si512' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2146: syntax error: missing ')' before identifier '__m512i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2059: syntax error: ')'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2297: '*': illegal, right operand has type 'char *'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2143: syntax error: missing ')' before ';'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(19): warning C4013: '_mm512_castsi512_si128' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(19): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(19): error C2440: 'function': cannot convert from 'int' to '__m128i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(19): warning C4024: '_mm_cvtsi128_si32': different types for formal and actual parameter 1

  WARN: CCompilerOpt.feature_test[1490] : testing failed
  WARN: CCompilerOpt.dist_test[590] : CCompilerOpt._dist_test_spawn[726] : Command (C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /TcC:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c /FoC:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.obj /arch:AVX2 /WX) failed with exit status 2 output ->
  cpu_avx512_skx.c
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2065: '__m512i': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2146: syntax error: missing ';' before identifier 'aa'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2065: 'aa': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): warning C4013: '_mm512_abs_epi32' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): warning C4013: '_mm512_loadu_si512' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2146: syntax error: missing ')' before identifier '__m512i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2059: syntax error: ')'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2297: '*': illegal, right operand has type 'char *'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2143: syntax error: missing ')' before ';'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(20): warning C4013: '_mm256_abs_epi64' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(20): warning C4013: '_mm512_extracti64x4_epi64' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(20): error C2065: 'aa': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(22): error C2065: '__m512i': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(22): error C2146: syntax error: missing ';' before identifier 'b'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(22): error C2065: 'b': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(22): warning C4013: '_mm512_broadcast_i32x8' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(24): error C2065: 'b': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(24): warning C4013: '_mm512_abs_epi16' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(25): warning C4013: '_mm512_castsi512_si128' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(25): error C2065: 'b': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(25): error C2440: 'function': cannot convert from 'int' to '__m128i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(25): warning C4024: '_mm_cvtsi128_si32': different types for formal and actual parameter 1
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(20): error C2440: 'initializing': cannot convert from 'int' to '__m256i'

  WARN: CCompilerOpt.feature_test[1490] : testing failed
  WARN: CCompilerOpt.dist_test[590] : CCompilerOpt._dist_test_spawn[726] : Command (C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /TcC:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c /FoC:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.obj /arch:AVX2 /WX) failed with exit status 2 output ->
  cpu_avx512_clx.c
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2065: '__m512i': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2146: syntax error: missing ';' before identifier 'a'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): warning C4013: '_mm512_loadu_si512' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2146: syntax error: missing ')' before identifier '__m512i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2059: syntax error: ')'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2297: '*': illegal, right operand has type 'char *'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2143: syntax error: missing ')' before ';'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(20): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(20): warning C4013: '_mm512_dpbusd_epi32' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(20): warning C4013: '_mm512_setzero_si512' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(21): warning C4013: '_mm512_castsi512_si128' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(21): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(21): error C2440: 'function': cannot convert from 'int' to '__m128i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(21): warning C4024: '_mm_cvtsi128_si32': different types for formal and actual parameter 1

  WARN: CCompilerOpt.feature_test[1490] : testing failed
  WARN: CCompilerOpt.generate_dispatch_header[2291] : dispatch header dir build\src.win-amd64-3.8\numpy\distutils\include does not exist, creating it
  creating build\temp.win-amd64-3.8
...
  creating build\temp.win-amd64-3.8\numpy\random\src\distributions
  running build_ext
  WARN: Missing compiler_cxx fix for MSVCCompiler
  creating build\temp.win-amd64-3.8\Release\build
...
  creating build\temp.win-amd64-3.8\Release\build\src.win-amd64-3.8\numpy\core\src\umath
  loops_trigonometric.dispatch.avx2.c
  numpy\core\src\npymath\npy_math_internal.h.src(897): warning C4244: 'return': conversion from 'unsigned short' to 'uint8_t', possible loss of data
  numpy\core\src\npymath\npy_math_internal.h.src(903): warning C4244: 'return': conversion from 'unsigned __int64' to 'uint8_t', possible loss of data
  numpy\core\src\umath\loops_trigonometric.dispatch.c.src(40): error C2059: syntax error: 'bad suffix on number'
  numpy\core\src\umath\loops_trigonometric.dispatch.c.src(40): warning C4305: 'function': truncation from 'double' to 'float'
...
  numpy\core\src\umath\loops_trigonometric.dispatch.c.src(109): warning C4305: 'function': truncation from 'double' to 'float'
  numpy\core\src\umath\loops_trigonometric.dispatch.c.src(110): error C2059: syntax error: 'bad suffix on number'
  Running from numpy source directory.
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\system_info.py:2077: UserWarning:
      Optimized (vendor) Blas libraries are not found.
      Falls back to netlib Blas library which has worse performance.
      A better performance should be easily gained by switching
      Blas library.
    if self._calc_info(blas):
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\system_info.py:2077: UserWarning:
      Blas (http://www.netlib.org/blas/) libraries not found.
      Directories to search for the libraries can be specified in the
      numpy/distutils/site.cfg file (section [blas]) or by setting
      the BLAS environment variable.
    if self._calc_info(blas):
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\system_info.py:2077: UserWarning:
      Blas (http://www.netlib.org/blas/) sources not found.
      Directories to search for the sources can be specified in the
      numpy/distutils/site.cfg file (section [blas_src]) or by setting
      the BLAS_SRC environment variable.
    if self._calc_info(blas):
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\system_info.py:1902: UserWarning:
      Lapack (http://www.netlib.org/lapack/) libraries not found.
      Directories to search for the libraries can be specified in the
      numpy/distutils/site.cfg file (section [lapack]) or by setting
      the LAPACK environment variable.
    return getattr(self, '_calc_info_{}'.format(name))()
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\system_info.py:1902: UserWarning:
      Lapack (http://www.netlib.org/lapack/) sources not found.
      Directories to search for the sources can be specified in the
      numpy/distutils/site.cfg file (section [lapack_src]) or by setting
      the LAPACK_SRC environment variable.
    return getattr(self, '_calc_info_{}'.format(name))()
  Warning: attempted relative import with no known parent package
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-build-env-qem0ndd3\overlay\Lib\site-packages\setuptools\_distutils\dist.py:275: UserWarning: Unknown distribution option: 'define_macros'
    warnings.warn(msg)
  error: Command "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -DNPY_INTERNAL_BUILD=1 -DHAVE_NPY_CONFIG_H=1 -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE=1 -D_LARGEFILE64_SOURCE=1 -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\umath -Inumpy\core\include -Ibuild\src.win-amd64-3.8\numpy\core\include/numpy -Ibuild\src.win-amd64-3.8\numpy\distutils\include -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /Tcbuild\src.win-amd64-3.8\numpy\core\src\umath\loops_trigonometric.dispatch.avx2.c /Fobuild\temp.win-amd64-3.8\Release\build\src.win-amd64-3.8\numpy\core\src\umath\loops_trigonometric.dispatch.avx2.obj /Zm1000 /O2 /arch:AVX2" failed with exit status 2
  [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
  ERROR: Failed building wheel for numpy
Failed to build numpy
ERROR: Could not build wheels for numpy, which is required to install pyproject.toml-based projects
```

答: The visual studio 14.0 compiler is very old, and cannot build NumPy. If you cannot update, you should use conda (as suggested by Abdullah Khilji) which will get you PyPy 3.7 if you do conda create -n pypyenv pypy3.7. More information at https://conda-forge.org/blog/posts/2020-03-10-pypy/

Body:
I am attempting to try out pypy, and I can install a few packages, but the important ones like Numpy and Pandas go boom!!!  I get similar issues if I try it within PyCharm.

see below.  Also at some point I also saw this error.

     Optimized (vendor) Blas libraries are not found.
      Falls back to netlib Blas library which has worse performance.
      A better performance should be easily gained by switching
      Blas library.

  Blas (http://www.netlib.org/blas/) libraries not found.
      Directories to search for the libraries can be specified in the
      numpy/distutils/site.cfg file (section [blas]) or by setting
      the BLAS environment variable.
```

```
pypy -m pip install --extra-index-url https://antocuni.github.io/pypy-wheels/manylinux2010 numpy

```
C:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64>pypy -m pip install --extra-index-url https://antocuni.github.io/pypy-wheels/manylinux2010 numpy
Looking in indexes: https://pypi.org/simple, https://antocuni.github.io/pypy-wheels/manylinux2010
warning: missing-index-doctype

The package index page being used does not have a proper HTML doctype declaration.

Problematic URL: https://antocuni.github.io/pypy-wheels/manylinux2010/numpy/

note: This is an issue with the page at the URL mentioned above.
hint: You might need to reach out to the owner of that package index, to get this fixed. See https://github.com/pypa/pip/issues/10825 for context.
Collecting numpy
  Using cached numpy-1.22.2.zip (11.4 MB)
  Installing build dependencies ... done
  Getting requirements to build wheel ... done
  Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: numpy
  Building wheel for numpy (pyproject.toml) ... error
  error: subprocess-exited-with-error

  Building wheel for numpy (pyproject.toml) did not run successfully.
  exit code: 1

  [690 lines of output]
  Processing numpy/random\_bounded_integers.pxd.in
...
  Processing numpy/random\_sfc64.pyx
  Cythonizing sources
  WARN: Could not locate executable g77
  WARN: Could not locate executable f77
  WARN: Could not locate executable ifort
  WARN: Could not locate executable ifl
  WARN: Could not locate executable f90
  WARN: Could not locate executable DF
  WARN: Could not locate executable efl
  WARN: Could not locate executable gfortran
  WARN: Could not locate executable f95
  WARN: Could not locate executable g95
  WARN: Could not locate executable efort
  WARN: Could not locate executable efc
  WARN: Could not locate executable flang
  WARN: don't know how to compile Fortran code on platform 'nt'
  non-existing path in 'numpy\\distutils': 'site.cfg'
  running bdist_wheel
  running build
...
  creating build\src.win-amd64-3.8\numpy\core\src\multiarray
  BUILD_ARCHITECTURE: 'AMD64', os.name='nt', sys.platform='win32'
  non-existing path in 'numpy\\core': 'build\\src.win-amd64-3.8\\numpy\\core\\src\\common'
  creating build\src.win-amd64-3.8\numpy\core\src\common
...
  creating build\src.win-amd64-3.8\numpy\linalg
  ### Warning:  Using unoptimized lapack ###
  ### Warning:  Using unoptimized lapack ###
  running build_py
...
  creating C:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks
  WARN: CCompilerOpt.__init__[1169] : feature 'AVX512_KNL' is disabled, MSVC compiler doesn't support it
  WARN: CCompilerOpt.__init__[1169] : feature 'AVX512_KNM' is disabled, MSVC compiler doesn't support it
  WARN: CCompilerOpt.dist_test[590] : CCompilerOpt._dist_test_spawn[714] : Flags in command (C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /TcC:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\test_flags.c /FoC:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\test_flags.obj /arch:AVX512) aren't supported by the compiler, output ->
  cl : Command line warning D9002 : ignoring unknown option '/arch:AVX512'
  test_flags.c

  WARN: CCompilerOpt.cc_test_flags[1025] : testing failed
  WARN: CCompilerOpt.dist_test[590] : CCompilerOpt._dist_test_spawn[726] : Command (C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /TcC:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c /FoC:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.obj /arch:AVX2 /WX) failed with exit status 2 output ->
  cpu_avx512cd.c
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2065: '__m512i': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2146: syntax error: missing ';' before identifier 'a'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): warning C4013: '_mm512_lzcnt_epi32' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): warning C4013: '_mm512_loadu_si512' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2146: syntax error: missing ')' before identifier '__m512i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2059: syntax error: ')'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2297: '*': illegal, right operand has type 'char *'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(18): error C2143: syntax error: missing ')' before ';'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(19): warning C4013: '_mm512_castsi512_si128' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(19): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(19): error C2440: 'function': cannot convert from 'int' to '__m128i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512cd.c(19): warning C4024: '_mm_cvtsi128_si32': different types for formal and actual parameter 1

  WARN: CCompilerOpt.feature_test[1490] : testing failed
  WARN: CCompilerOpt.dist_test[590] : CCompilerOpt._dist_test_spawn[726] : Command (C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /TcC:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c /FoC:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.obj /arch:AVX2 /WX) failed with exit status 2 output ->
  cpu_avx512f.c
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2065: '__m512i': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2146: syntax error: missing ';' before identifier 'a'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): warning C4013: '_mm512_abs_epi32' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): warning C4013: '_mm512_loadu_si512' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2146: syntax error: missing ')' before identifier '__m512i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2059: syntax error: ')'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2297: '*': illegal, right operand has type 'char *'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(18): error C2143: syntax error: missing ')' before ';'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(19): warning C4013: '_mm512_castsi512_si128' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(19): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(19): error C2440: 'function': cannot convert from 'int' to '__m128i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512f.c(19): warning C4024: '_mm_cvtsi128_si32': different types for formal and actual parameter 1

  WARN: CCompilerOpt.feature_test[1490] : testing failed
  WARN: CCompilerOpt.dist_test[590] : CCompilerOpt._dist_test_spawn[726] : Command (C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /TcC:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c /FoC:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.obj /arch:AVX2 /WX) failed with exit status 2 output ->
  cpu_avx512_skx.c
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2065: '__m512i': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2146: syntax error: missing ';' before identifier 'aa'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2065: 'aa': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): warning C4013: '_mm512_abs_epi32' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): warning C4013: '_mm512_loadu_si512' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2146: syntax error: missing ')' before identifier '__m512i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2059: syntax error: ')'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2297: '*': illegal, right operand has type 'char *'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(18): error C2143: syntax error: missing ')' before ';'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(20): warning C4013: '_mm256_abs_epi64' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(20): warning C4013: '_mm512_extracti64x4_epi64' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(20): error C2065: 'aa': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(22): error C2065: '__m512i': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(22): error C2146: syntax error: missing ';' before identifier 'b'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(22): error C2065: 'b': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(22): warning C4013: '_mm512_broadcast_i32x8' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(24): error C2065: 'b': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(24): warning C4013: '_mm512_abs_epi16' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(25): warning C4013: '_mm512_castsi512_si128' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(25): error C2065: 'b': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(25): error C2440: 'function': cannot convert from 'int' to '__m128i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(25): warning C4024: '_mm_cvtsi128_si32': different types for formal and actual parameter 1
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_skx.c(20): error C2440: 'initializing': cannot convert from 'int' to '__m256i'

  WARN: CCompilerOpt.feature_test[1490] : testing failed
  WARN: CCompilerOpt.dist_test[590] : CCompilerOpt._dist_test_spawn[726] : Command (C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /TcC:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c /FoC:\Users\QUENTI~1\AppData\Local\Temp\tmp2x_oanlm\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.obj /arch:AVX2 /WX) failed with exit status 2 output ->
  cpu_avx512_clx.c
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2065: '__m512i': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2146: syntax error: missing ';' before identifier 'a'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): warning C4013: '_mm512_loadu_si512' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2146: syntax error: missing ')' before identifier '__m512i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2059: syntax error: ')'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2297: '*': illegal, right operand has type 'char *'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(19): error C2143: syntax error: missing ')' before ';'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(20): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(20): warning C4013: '_mm512_dpbusd_epi32' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(20): warning C4013: '_mm512_setzero_si512' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(21): warning C4013: '_mm512_castsi512_si128' undefined; assuming extern returning int
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(21): error C2065: 'a': undeclared identifier
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(21): error C2440: 'function': cannot convert from 'int' to '__m128i'
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\checks\cpu_avx512_clx.c(21): warning C4024: '_mm_cvtsi128_si32': different types for formal and actual parameter 1

  WARN: CCompilerOpt.feature_test[1490] : testing failed
  WARN: CCompilerOpt.generate_dispatch_header[2291] : dispatch header dir build\src.win-amd64-3.8\numpy\distutils\include does not exist, creating it
  creating build\temp.win-amd64-3.8
...
  creating build\temp.win-amd64-3.8\numpy\random\src\distributions
  running build_ext
  WARN: Missing compiler_cxx fix for MSVCCompiler
  creating build\temp.win-amd64-3.8\Release\build
...
  creating build\temp.win-amd64-3.8\Release\build\src.win-amd64-3.8\numpy\core\src\umath
  loops_trigonometric.dispatch.avx2.c
  numpy\core\src\npymath\npy_math_internal.h.src(897): warning C4244: 'return': conversion from 'unsigned short' to 'uint8_t', possible loss of data
  numpy\core\src\npymath\npy_math_internal.h.src(903): warning C4244: 'return': conversion from 'unsigned __int64' to 'uint8_t', possible loss of data
  numpy\core\src\umath\loops_trigonometric.dispatch.c.src(40): error C2059: syntax error: 'bad suffix on number'
  numpy\core\src\umath\loops_trigonometric.dispatch.c.src(40): warning C4305: 'function': truncation from 'double' to 'float'
...
  numpy\core\src\umath\loops_trigonometric.dispatch.c.src(109): warning C4305: 'function': truncation from 'double' to 'float'
  numpy\core\src\umath\loops_trigonometric.dispatch.c.src(110): error C2059: syntax error: 'bad suffix on number'
  Running from numpy source directory.
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\system_info.py:2077: UserWarning:
      Optimized (vendor) Blas libraries are not found.
      Falls back to netlib Blas library which has worse performance.
      A better performance should be easily gained by switching
      Blas library.
    if self._calc_info(blas):
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\system_info.py:2077: UserWarning:
      Blas (http://www.netlib.org/blas/) libraries not found.
      Directories to search for the libraries can be specified in the
      numpy/distutils/site.cfg file (section [blas]) or by setting
      the BLAS environment variable.
    if self._calc_info(blas):
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\system_info.py:2077: UserWarning:
      Blas (http://www.netlib.org/blas/) sources not found.
      Directories to search for the sources can be specified in the
      numpy/distutils/site.cfg file (section [blas_src]) or by setting
      the BLAS_SRC environment variable.
    if self._calc_info(blas):
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\system_info.py:1902: UserWarning:
      Lapack (http://www.netlib.org/lapack/) libraries not found.
      Directories to search for the libraries can be specified in the
      numpy/distutils/site.cfg file (section [lapack]) or by setting
      the LAPACK environment variable.
    return getattr(self, '_calc_info_{}'.format(name))()
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-install-a470u9k7\numpy_24426d81db7f45d5a2e20cd49f3e097f\numpy\distutils\system_info.py:1902: UserWarning:
      Lapack (http://www.netlib.org/lapack/) sources not found.
      Directories to search for the sources can be specified in the
      numpy/distutils/site.cfg file (section [lapack_src]) or by setting
      the LAPACK_SRC environment variable.
    return getattr(self, '_calc_info_{}'.format(name))()
  Warning: attempted relative import with no known parent package
  C:\Users\QUENTI~1\AppData\Local\Temp\pip-build-env-qem0ndd3\overlay\Lib\site-packages\setuptools\_distutils\dist.py:275: UserWarning: Unknown distribution option: 'define_macros'
    warnings.warn(msg)
  error: Command "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe /c /nologo /O2 /W3 /GL /DNDEBUG /MD -DNPY_INTERNAL_BUILD=1 -DHAVE_NPY_CONFIG_H=1 -D_FILE_OFFSET_BITS=64 -D_LARGEFILE_SOURCE=1 -D_LARGEFILE64_SOURCE=1 -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\umath -Inumpy\core\include -Ibuild\src.win-amd64-3.8\numpy\core\include/numpy -Ibuild\src.win-amd64-3.8\numpy\distutils\include -Inumpy\core\src\common -Inumpy\core\src -Inumpy\core -Inumpy\core\src\npymath -Inumpy\core\src\multiarray -Inumpy\core\src\umath -Inumpy\core\src\npysort -Inumpy\core\src\_simd -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -IC:\Users\Quentin_Sarafinchan\pypy\pypy3.8-v7.3.7-win64\include -Ibuild\src.win-amd64-3.8\numpy\core\src\common -Ibuild\src.win-amd64-3.8\numpy\core\src\npymath -IC:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\INCLUDE -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\ucrt -IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.6.1\include\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\shared -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\um -IC:\Program Files (x86)\Windows Kits\10\include\10.0.14393.0\winrt /Tcbuild\src.win-amd64-3.8\numpy\core\src\umath\loops_trigonometric.dispatch.avx2.c /Fobuild\temp.win-amd64-3.8\Release\build\src.win-amd64-3.8\numpy\core\src\umath\loops_trigonometric.dispatch.avx2.obj /Zm1000 /O2 /arch:AVX2" failed with exit status 2
  [end of output]

  note: This error originates from a subprocess, and is likely not a problem with pip.
  ERROR: Failed building wheel for numpy
Failed to build numpy
ERROR: Could not build wheels for numpy, which is required to install pyproject.toml-based projects


来源: stackexchange

问:
Nativescript/Angular Navigating Back is not working in Children Page
I navagate from main/tv-theke-page to main-tvtheke/main-tvtheke-home-page,
but when i press back in android  does not navigate back to main/tv-theke-page it exits from app

It seems is something wrong with route history

```<code>const routes: Routes = [
  { path: '', redirectTo: '/main', pathMatch: 'full' },
  { path: 'main', component: MainComponent ,
  children : [
    { path: '', component: HomePageComponent},
    { path: 'search-page', component: SearchPageComponent},
    { path: 'home-page', component: HomePageComponent},
    { path: 'live-tv-page', component: LiveTvPageComponent},
    { path: 'tvtheke-page', component: TvThekePageComponent},
    { path: 'music-page', component: MusicPageComponent},
    { path: 'movie-page', component: MoviePageComponent},
    { path: 'tv-show-page', component: TvShowPageComponent},
    { path: 'favorite-page', component: FavoritePageComponent},
  ]},
  { path: 'main-movie', component: MainMoviePageComponent},
  { path: 'main-tvshow', component: MainTVShowPageComponent},
  { path: 'main-tvtheke', component: MainTVThekeComponent ,
  children : [
    { path: '', component: MainTVThekeHomePageComponent},
    { path: 'main-tvtheke-home-page', component: MainTVThekeHomePageComponent},
    { path: 'main-tvtheke-dailyvdeos-page', component: MainTVThekeDailyVideosComponent},
    { path: 'main-tvtheke-rubric-page', component: MainTVThekeRubricComponent},
    { path: 'main-tvtheke-az-page', component: MainTVThekeAZComponent},
  ]},
]
</code>```

答:
That really depends on how you navigation logic looks.
I would suggest you create a playground with your sample here:
https://play.nativescript.org/

Also, you might get more info by enabling router tracing in you app-routing.module

```<code>@NgModule({
    imports: [
        NativeScriptRouterModule.forRoot(routes, {
            enableTracing: true,
</code>```

ContentLicense: CC BY-SA 4.0

Body:
I navagate from main/tv-theke-page to main-tvtheke/main-tvtheke-home-page,
but when i press back in android  does not navigate back to main/tv-theke-page it exits from app

It seems is something wrong with route history

const routes: Routes = [
  { path: '', redirectTo: '/main', pathMatch: 'full' },
  { path: 'main', component: MainComponent ,
  children : [
    { path: '', component: HomePageComponent},
    { path: 'search-page', component: SearchPageComponent},
    { path: 'home-page', component: HomePageComponent},
    { path: 'live-tv-page', component: LiveTvPageComponent},
    { path: 'tvtheke-page', component: TvThekePageComponent},
    { path: 'music-page', component: MusicPageComponent},
    { path: 'movie-page', component: MoviePageComponent},
    { path: 'tv-show-page', component: TvShowPageComponent},
    { path: 'favorite-page', component: FavoritePageComponent},
  ]},
  { path: 'main-movie', component: MainMoviePageComponent},
  { path: 'main-tvshow', component: MainTVShowPageComponent},
  { path: 'main-tvtheke', component: MainTVThekeComponent ,
  children : [
    { path: '', component: MainTVThekeHomePageComponent},
    { path: 'main-tvtheke-home-page', component: MainTVThekeHomePageComponent},
    { path: 'main-tvtheke-dailyvdeos-page', component: MainTVThekeDailyVideosComponent},
    { path: 'main-tvtheke-rubric-page', component: MainTVThekeRubricComponent},
    { path: 'main-tvtheke-az-page', component: MainTVThekeAZComponent},
  ]},
]

Body:
That really depends on how you navigation logic looks.
I would suggest you create a playground with your sample here:
https://play.nativescript.org/

Also, you might get more info by enabling router tracing in you app-routing.module

@NgModule({
    imports: [
        NativeScriptRouterModule.forRoot(routes, {
            enableTracing: true,


问:
Reading inputs in java
```<code>import java.io.*;
public class inputting {
/**
* @param args
* @throws IOException
*/
public static void main(String[] args) throws IOException {
// TODO Auto-generated method stub
BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
System.out.println("number??");
String str;
     int i=0;
    while (i<5) {
            str=br.readLine();
            int n = Integer.parseInt(str);
            System.out.println(n);
        i++;}
}
</code>```

}

if i want to read 5 integers how do i do that? what extra code i need to write?

答:
wrap your readline in a while loop that checks for user input to quit</p>

```<code>        while ( !(str = br.readLine()).equalsIgnoreCase("q")) {
            int n = Integer.parseInt(str);
            System.out.println(n);
        }
</code>```

ContentLicense: CC BY-SA 3.0

Title: Reading inputs in java

Body:
import java.io.*;
public class inputting {
/**
* @param args
* @throws IOException
*/
public static void main(String[] args) throws IOException {
// TODO Auto-generated method stub
BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
System.out.println("number??");
String str;
     int i=0;
    while (i<5) {
            str=br.readLine();
            int n = Integer.parseInt(str);
            System.out.println(n);
        i++;}
}

}

if i want to read 5 integers how do i do that? what extra code i need to write?

Body:
wrap your readline in a while loop that checks for user input to quit

        while ( !(str = br.readLine()).equalsIgnoreCase("q")) {
            int n = Integer.parseInt(str);
            System.out.println(n);
        }


问:
ValueError: Input 0 of layer lstm is incompatible with the layer: expected ndim=3, found ndim=4. Full shape received: [None, 7, 5, 4]
self.LSTM  = LSTM((1),input_shape=[7,5, 4])

This is how i have defined my LSTM layer, here 5 are the no of timesteps and 4 are no of features and 7 are no of agents, I want the output in the shape of [batchsize,7,4] but I am getting the error "ValueError: Input 0 of layer lstm is incompatible with the layer: expected ndim=3, found ndim=4. Full shape received: [None, 7, 5, 4]"

Any idea how I can implement this ?

答:
LSTM takes inputs: A 3D tensor with shape [batch, timesteps, feature]

```<code>import tensorflow as tf
inputs = tf.random.normal([7, 5, 4])
lstm = tf.keras.layers.LSTM(4, return_sequences=True)
output = lstm(inputs)
print(output.shape)
</code>```

Output

```<code>(7, 5, 4)
</code>```

Body:
LSTM takes inputs: A 3D tensor with shape [batch, timesteps, feature]

import tensorflow as tf
inputs = tf.random.normal([7, 5, 4])
lstm = tf.keras.layers.LSTM(4, return_sequences=True)
output = lstm(inputs)
print(output.shape)

Output

(7, 5, 4)


问:
Delete a huge number of tables in one DROP TABLE Postgres
Does Postgres have any limits for a number of tables to be deleted in one DROP TABLE command (about 10000 in my case)? Does it depend on the version? Will it be faster than executing the command 10 times & 1000 tables?

The possibilities for testing this are limited in my case, so please share if you've had a similar experience.

答: There is no theoretical limit on the number of tables you can drop in one statement. However, each table dropped will require a couple of ACCESS EXCLUSIVE locks, which are retained in the locking table until the end of the transaction, so you will exceed the default limit of 6400 locks at some point. Increasing max_locks_per_transaction will increase the limit and is safe to do.


问:
max date filter in joining tables sql
I have the following ERD

I want to have a report like this

```<code>student_name | student_lastname | class_level | class_month | academic_calendar_start_date
</code>```

where it shows the last class taken by every student.

答: Try to join the table using JOIN  so you can get the data what you have asked

Title: max date filter in joining tables sql

Body:
I have the following ERD

I want to have a report like this

student_name | student_lastname | class_level | class_month | academic_calendar_start_date

where it shows the last class taken by every student.


问:
How to grant a SELECT permission for a new GCP Cloud SQL PostgreSQL user?
I need to read from an existing GCP Cloud SQL Postgres database.  I created a new user using a GCP console.  When I log in as that user I get "access denied" whenever I attempt to SELECT from any table.  I tried all kinds of ALLOW and GRANT with no luck.

The most bizarre behavior is "database not found" response when I run GRANT ALL PRIVILEGES ON DATABASE.  It says "database doesn't exist" despite it most definitely existing.

What commands need to be executed on a user created via GCP console so that the user can SELECT from the tables?

Thanks

答:
There are two aspects in this question, before exploring these, it is important to understand the differences between IAM and SQL users.

IAM users, when created, do not have any inherent right to read data inside the database. Permission to the database and tables must be explicitly granted to the IAM user from within Postgres using the 'grant' command

Creating a user with Postgres internal commands, the level of access is determined by the role it is associated with as mentioned in link1, link2.
In this specific case, you should use an account that does have permission to grant the IAM role the appropriate permissions.
As you do not have the postgresql password, you will have to reset it like in [5]

While it was already stated this is in production, there is no other way. Only an existing user with appropriate permissions can update the database to change permissions as this is done within the Database itself.

[5] gcloud sql users set-password postgres --instance=<DBNAME> --prompt-for-password


问:
How do I implement action={% url '......' %} in django-form
I want to know the equivalent using <form action={% url '......' %}> in django-form(i.e. using forms.ModelForm class).

How do I define the action url of my form in djano-form? it can be easily done in HTML using action attribute of form as action={% url....

答:
The form action in views.py will run when you click <button type='submit'> Submit </button>  in your <form>. If it's not what you want:

That is how you can trigger a view function from html :

views.py

```<code>def YourAction(request, arg):
    # do something
    return redirect('/anywhere') # you need to return something
</code>```

urls.py

```<code>from .views import YourAction
urlpatterns = [
   path('dosomething/<arg>', YourAction, name='action_name'),
]
</code>```

your html

```<code><form action='{% url 'action_name' arg %}'>
   <button type='submit'> Submit! </button>
</form>
</code>```

You don't have to use form. You can just use  Do Something!

Body:
The form action in views.py will run when you click <button type='submit'> Submit </button>  in your <form>. If it's not what you want:

That is how you can trigger a view function from html :

views.py

def YourAction(request, arg):
    # do something
    return redirect('/anywhere') # you need to return something

urls.py

from .views import YourAction
urlpatterns = [
   path('dosomething/<arg>', YourAction, name='action_name'),
]

your html

<form action='{% url 'action_name' arg %}'>
   <button type='submit'> Submit! </button>
</form>

You don't have to use form. You can just use <a href='{% url 'action_name' arg %}'> Do Something! </a>


问:
Regex Conditional validation
I have a input field, and I want to create a regex that only receive input value from 0.00 to 100.00(include both). I have created a regex check:

```<code>^1?\d{0,2}(\.\d{1,2})?$
</code>```

But with this one, it not only accept values from 0.00 to 100.00 but also accept the input from 100.01 to 199.99.

How can I set a condition that if there are three digital before the dot, it can be only 100 and the decimals part is 00 or 0 only if having decimals?

So 100.00, 100.0 or 100 are the only accept for the values over 99.99 and the input between 100.01 to 199.99 is not pass.

Here are some passed input:

```<code>100
100.00
100.0
3
0
0.00
5.2
8.21
37.23
</code>```

Here are some not passed:

```<code>40.323
100.50
101.50
199.99
40.
100.
</code>```

答:
Try this:

```<code>^(100(\.00?)?|\d\d?)(\.\d\d?)?$
</code>```

See live demo.

Regex:

^ = start

(100|\d\d?) =  literal 100 or 1 or 2 digits

(\.\d\d?)? = dot then 1 or 2 digits, all optional

$ = end

Title: Regex Conditional validation

Body:
I have a input field, and I want to create a regex that only receive input value from 0.00 to 100.00(include both). I have created a regex check:

^1?\d{0,2}(\.\d{1,2})?$

But with this one, it not only accept values from 0.00 to 100.00 but also accept the input from 100.01 to 199.99.

How can I set a condition that if there are three digital before the dot, it can be only 100 and the decimals part is 00 or 0 only if having decimals?

So 100.00, 100.0 or 100 are the only accept for the values over 99.99 and the input between 100.01 to 199.99 is not pass.

Here are some passed input:

100
100.00
100.0
3
0
0.00
5.2
8.21
37.23

Here are some not passed:

40.323
100.50
101.50
199.99
40.
100.

Body:
Try this:

^(100(\.00?)?|\d\d?)(\.\d\d?)?$

See live demo.

Regex:

^ = start

(100|\d\d?) =  literal 100 or 1 or 2 digits

(\.\d\d?)? = dot then 1 or 2 digits, all optional

$ = end


问:
Pytorch expects each tensor to be equal size
When running this code: embedding_matrix = torch.stack(embeddings)

I got this error:

```<code>RuntimeError: stack expects each tensor to be equal size, but got [7, 768] at entry 0 and [8, 768] at entry 1
</code>```

I'm trying to get embedding using BERT via:

```<code>    split_sent = sent.split()
    tokens_embedding = []
    j = 0
    for full_token in split_sent:
        curr_token = ''
        x = 0
        for i,_ in enumerate(tokenized_sent[1:]):
            token = tokenized_sent[i+j]
            piece_embedding = bert_embedding[i+j]
            if token == full_token and curr_token == '' :
               tokens_embedding.append(piece_embedding)
               j += 1
               break
    sent_embedding = torch.stack(tokens_embedding)
    embeddings.append(sent_embedding)
embedding_matrix = torch.stack(embeddings)
</code>```

Does anyone know how I can fix this?

答: As per PyTorch Docs about torch.stack() function, it needs the input tensors in the same shape to stack. I don't know how will you be using the embedding_matrix but either you can add padding to your tensors (which will be a list of zeros at the end till a certain user-defined length and is recommended if you will train with this stacked tensor, refer this tutorial) to make them equidimensional or you can simply use something like torch.cat(data,dim=0).

Body:
When running this code: embedding_matrix = torch.stack(embeddings)

I got this error:

RuntimeError: stack expects each tensor to be equal size, but got [7, 768] at entry 0 and [8, 768] at entry 1

I'm trying to get embedding using BERT via:

    split_sent = sent.split()
    tokens_embedding = []
    j = 0
    for full_token in split_sent:
        curr_token = ''
        x = 0
        for i,_ in enumerate(tokenized_sent[1:]):
            token = tokenized_sent[i+j]
            piece_embedding = bert_embedding[i+j]
            if token == full_token and curr_token == '' :
               tokens_embedding.append(piece_embedding)
               j += 1
               break
    sent_embedding = torch.stack(tokens_embedding)
    embeddings.append(sent_embedding)
embedding_matrix = torch.stack(embeddings)

Does anyone know how I can fix this?


问:
disabled button after submit form with model validation asp.net core
How Can I disable button after submit form with model validation in asp.net core?

code:

```<code>                    <form action="/AddComment" method="post" id="InsertCommentForm">
                        <div asp-validation-summary="ModelOnly" class="text-danger"></div>
                        <div class="form-group">
                            <input type="hidden" asp-for="ProductId" />
                            <input type="hidden" asp-for="ParentId" value="" id="reply" />
                            <input asp-for="Email" id="Email" class="form-control mrg15B" placeholder="لطـفا یک ایمیل معتبر وارد کنید">
                            <span asp-validation-for="Email" class="text-danger"></span>

                            <input asp-for="FullName" id="FullName" class="form-control mrg15B" placeholder="لطـفا نام خود را وارد کنید">
                            <span asp-validation-for="FullName" class="text-danger"></span>

                            <textarea asp-for="Text" id="Text" class="form-control mrg15B area" cols="60" rows="5" placeholder="لطفا متن پیام را وارد کنید"></textarea>
                            <span asp-validation-for="Text" class="text-danger"></span>

                            <br />
                            <input type="submit" value="ارسال" id="InsertCommentBtn" class="btn btn-warning">
                        </div>
                    </form>
</code>```

I tested several times, but if the validation model starts working and prevents the form from being posted, the Disable button remains.

Thankyou

答:
You need use validate() method in jquery.validate.js(the js file has been referenced in _ValidationScriptsPartial.cshtml by default) to validate the form. Only when the validation passed, the button would be disabled:

```<code>@section Scripts {
    @{await Html.RenderPartialAsync("_ValidationScriptsPartial");}
    <script>
        $("#InsertCommentForm").on("submit", function(event) {
            var validator = $("#InsertCommentForm" ).validate();
            var flag = validator.form();
            if(flag)
            {
                $('input[type="submit"]').attr('disabled',true);
            }

        });
    </script>
}
</code>```

Body:
How Can I disable button after submit form with model validation in asp.net core?

code:

                    <form action="/AddComment" method="post" id="InsertCommentForm">

                            <input type="hidden" asp-for="ProductId" />
                            <input type="hidden" asp-for="ParentId" value="" id="reply" />
                            <input asp-for="Email" id="Email" class="form-control mrg15B" placeholder="لطـفا یک ایمیل معتبر وارد کنید">

                            <input asp-for="FullName" id="FullName" class="form-control mrg15B" placeholder="لطـفا نام خود را وارد کنید">

                            <textarea asp-for="Text" id="Text" class="form-control mrg15B area" cols="60" rows="5" placeholder="لطفا متن پیام را وارد کنید"></textarea>

                            <input type="submit" value="ارسال" id="InsertCommentBtn" class="btn btn-warning">

                    </form>

I tested several times, but if the validation model starts working and prevents the form from being posted, the Disable button remains.

Thankyou

Body:
You need use validate() method in jquery.validate.js(the js file has been referenced in _ValidationScriptsPartial.cshtml by default) to validate the form. Only when the validation passed, the button would be disabled:

@section Scripts {
    @{await Html.RenderPartialAsync("_ValidationScriptsPartial");}
    <script>
        $("#InsertCommentForm").on("submit", function(event) {
            var validator = $("#InsertCommentForm" ).validate();
            var flag = validator.form();
            if(flag)
            {
                $('input[type="submit"]').attr('disabled',true);
            }

        });
    </script>
}


问:
Connecting from one AWS Elastic Beanstalk environment to another
I have 2 Elastic Beanstalk environments, "api-server" & "website". Both have a capacity of 1-4 EC2 instances and a load balancer. The load balancer and the instances have both public IP addresses. I want to connect from the "website"  to the "api-server" but i can't get it to work without making the "api-server" public. The "api-server" should not be public.

I am connected with a VPN that is allowed HTTP connections to both EB environments and i can confirm that both apps respond.

Both EB environments have 2 security groups, one for the load balancer called "Load Balancer Security Group" and one for the instances called "VPC Security Group". All load balancer and VPC security groups have an outbound rule allowing all traffic on all protocols.

Since i want to connect from the "website" to any of the instances of "api-server" i want to connect to the load balancer and not to any of the instances directly. So i should add an inbound rule to the load balancer group of the "api-server" that allows traffic from the "website"'s instances.

The instances all have the "VPC Security Group" but adding the rule did not give the "website" instances access to the "api-server". I also tried adding the load balancer security group without success. And i also tried the type "All traffic".

I also tried to connect to the "api-server" over different URLs like the load balancer but also no connection possible.

When i add a rule that allows traffic to everywhere, eg. source type "Anywhere-IPv4", i can access the "api-server" from the website. But as i said i don't want the "api-server" public it should be accessible only by the "website".

What also works is adding a rule with the IP address of the current "website" instance, but since they change with deployment of a new version and they are sometimes more or less instances (autoscaled from 1 to 4) its not an option.

So how does it work?

I searched everywhere in the docs but i can't find anything i didn't already tried. What am i missing? This surely shouldn't be so hard?

I appreciate every help!

Edit: Everything is in the same VPC.

答:
So how does it work?

Referencing security groups (SGs) works only withing VPC or peered VPCs. Since you are accessing your second EB over the internet, not within same VPC, you can't reference SGs.

You have to whitelist public IP addresses of your instances. The best way is to put them in private subnet and use NAT gateway. The NAT gives you a single public static IP which you can use in your ingress rule of the second EB environment.


问:
SQL request for filter change produtc price. Rails app with PostgreSQL
Please tell me how you can make a query using SQL or ActiveRecord. I have table price_history: id, product_id, price, date . I need to sort those products whose price has changed more than 2 times. I am new to SQL. My application uses Ruby-on-Rails and PostgreSQL . I will be glad for any help. Thank you.

I probably didn't formulate my question clearly. I need to get something like the following:

```<code>table: prices_history
id  | product | price | date
--------------------------------
1     milk      2.0     01/01/2022
2     milk      2.5     10/01/2022
3     milk      6.0     20/02/2022
4     bread     2.0     01/01/2022
5     bread     2.1     10/01/2022
6     bread     3.0     20/02/2022

SQL request =>
milk: min_price = 2.0, max_price = 6.0, max_price/min_price = 3 > 2? it`s true
bread: min_price = 2.0, max_price = 3.0, max_price/min_price = 1,5 > 2? it`s false

result SQL request = > milk
</code>```

答:
I think just a simple query will give you the result you need.

```<code>SELECT
    id,
    price,
    date,
    product_id,
    count (product_id)
FROM
    price_history
GROUP BY
    product_id
HAVING
    count (product_id) > 2;

</code>```

more info on having function: https://www.postgresqltutorial.com/postgresql-having

Body:
Please tell me how you can make a query using SQL or ActiveRecord. I have table price_history: id, product_id, price, date . I need to sort those products whose price has changed more than 2 times. I am new to SQL. My application uses Ruby-on-Rails and PostgreSQL . I will be glad for any help. Thank you.

I probably didn't formulate my question clearly. I need to get something like the following:

table: prices_history
id  | product | price | date
--------------------------------
1     milk      2.0     01/01/2022
2     milk      2.5     10/01/2022
3     milk      6.0     20/02/2022
4     bread     2.0     01/01/2022
5     bread     2.1     10/01/2022
6     bread     3.0     20/02/2022

SQL request =>
milk: min_price = 2.0, max_price = 6.0, max_price/min_price = 3 > 2? it`s true
bread: min_price = 2.0, max_price = 3.0, max_price/min_price = 1,5 > 2? it`s false

result SQL request = > milk

Body:
I think just a simple query will give you the result you need.

SELECT
    id,
    price,
    date,
    product_id,
    count (product_id)
FROM
    price_history
GROUP BY
    product_id
HAVING
    count (product_id) > 2;

more info on having function: https://www.postgresqltutorial.com/postgresql-having


问:
Custom Iterable<T>.sumOf function not working across different modules
I have this data class with me defined in module A:

```<code>data class Amount(val value: Int)
</code>```

And I have created the following extension function (also in module A):

inline fun <T> Iterable<T>.sumOf(selector: (T) -> Amount): Amount {
    var sum = 0
    for (element in this)
        sum += selector(element).value
    return Amount(sum)
}
```
<p>An example usage looks like this:</p>
<pre class="lang-kotlin prettyprint-override"><code>val sum: Amount = (1..5).sumOf { Amount(it) }
</code>```

When I use this sumOf function in module A, it works perfectly but when I try to use it in a different module B (which has a dependency on module A), the compiler is not able to find this overload of sumOf function.

If I rename sumOf to something different (like sumBy etc.) then it works in module B as well. Another thing I noticed is that even if I put that extension function in module B, the compiler isn't able to find this overload. The error it shows is:

```<code>None of the following functions can be called with the arguments supplied.
Iterable<TypeVariable(T)>.sumOf((TypeVariable(T)) → Int)   where T = TypeVariable(T) for    inline fun <T> Iterable<T>.sumOf(selector: (T) → Int): Int defined in kotlin.collections

followed by similar other overloads available for Long, ULong, etc.
</code>```

What's the problem here?

答:
Most probably you didn't import your function, so it was at all ignored. Note that Kotlin stdlib already have a function with almost the same signature (Iterable<T>.sumOf()), so IDE probably don't even suggest you importing your custom function, but just uses the "standard" one.

It worked from A probably because you called it from the same package (just my guess), so it didn't require importing.

To fix this problem you would need to import your function manually, but I suggest not using this name at all. It will always cause confusion and problems - both to the compiler and to people who read the code and don't expect that sumOf() does a different thing than usual. Just name it sumOfAmounts().

Body:
I have this data class with me defined in module A:

data class Amount(val value: Int)

And I have created the following extension function (also in module A):

inline fun <T> Iterable<T>.sumOf(selector: (T) -> Amount): Amount {
    var sum = 0
    for (element in this)
        sum += selector(element).value
    return Amount(sum)
}

An example usage looks like this:

val sum: Amount = (1..5).sumOf { Amount(it) }

When I use this sumOf function in module A, it works perfectly but when I try to use it in a different module B (which has a dependency on module A), the compiler is not able to find this overload of sumOf function.

If I rename sumOf to something different (like sumBy etc.) then it works in module B as well. Another thing I noticed is that even if I put that extension function in module B, the compiler isn't able to find this overload. The error it shows is:

None of the following functions can be called with the arguments supplied.
Iterable<TypeVariable(T)>.sumOf((TypeVariable(T)) → Int)   where T = TypeVariable(T) for    inline fun <T> Iterable<T>.sumOf(selector: (T) → Int): Int defined in kotlin.collections

followed by similar other overloads available for Long, ULong, etc.

What's the problem here?


问:
SELECT top value of each country
Using Google BigQuery, this is the expected output

Find the top vendor (display vendor name) by GMV in each country

Country_name
Vendor_name
total_gmv

Taiwan
Sweet Chinese Desserts
4029.62

Thailand
9th Cafe House
576.0

Singapore
IC House
123.772

My current method (I cannot figure out how to proceed)

```<code>SELECT O.country_name, V.vendor_name, O.gmv_local as total_gmv, PERCENT_RANK() OVER (PARTITION BY O.country_name ORDER BY O.gmv_local) AS Pct_rank
FROM Orders O
JOIN Vendors V
  ON O.vendor_id = V.id
ORDER BY 4 DESC;
</code>```

Order Table: vendor_id, country_name, gmv_local

Vendor Table: id, vendor_name

答:
You can use ROW_NUMBER() method in your query.

Query :

```<code>WITH cte AS (
    SELECT Ord.country_name, vn.vendor_name, ROUND(SUM(Ord.gmv_local), 2) AS total_gmv,
           ROW_NUMBER() OVER (PARTITION BY Ord.country_name
                              ORDER BY SUM(Ord.gmv_local) DESC) rn
    FROM `data2.orders` AS Ord
    LEFT JOIN `data2.vendor` AS vn
        ON Ord.vendor_id = vn.id
    GROUP BY Ord.country_name, vn.vendor_name
)

SELECT country_name, vendor_name, total_gmv
FROM cte
WHERE rn < 2
ORDER BY country_name, total_gmv DESC;
</code>```

output:

Title: SELECT top value of each country

Body:
Using Google BigQuery, this is the expected output

Find the top vendor (display vendor name) by GMV in each country

Country_name
Vendor_name
total_gmv

Taiwan
Sweet Chinese Desserts
4029.62

Thailand
9th Cafe House
576.0

Singapore
IC House
123.772

My current method (I cannot figure out how to proceed)

SELECT O.country_name, V.vendor_name, O.gmv_local as total_gmv, PERCENT_RANK() OVER (PARTITION BY O.country_name ORDER BY O.gmv_local) AS Pct_rank
FROM Orders O
JOIN Vendors V
  ON O.vendor_id = V.id
ORDER BY 4 DESC;

Order Table: vendor_id, country_name, gmv_local

Vendor Table: id, vendor_name

Body:
You can use ROW_NUMBER() method in your query.

Query :

WITH cte AS (
    SELECT Ord.country_name, vn.vendor_name, ROUND(SUM(Ord.gmv_local), 2) AS total_gmv,
           ROW_NUMBER() OVER (PARTITION BY Ord.country_name
                              ORDER BY SUM(Ord.gmv_local) DESC) rn
    FROM `data2.orders` AS Ord
    LEFT JOIN `data2.vendor` AS vn
        ON Ord.vendor_id = vn.id
    GROUP BY Ord.country_name, vn.vendor_name
)

SELECT country_name, vendor_name, total_gmv
FROM cte
WHERE rn < 2
ORDER BY country_name, total_gmv DESC;

output:


问:
React showing value required on edit case even if the field is already populated
I am using react-hook-form and Joi for the validataion in react. But in case of edit, if I don't touch any field and hit directly update, it shows value required, even when the field is already populated there.

But, once I focus or clicked on the input field, and hit update, then its get updated.

Here is the form:

```<code>const MarketplaceForm = ({ submitAction, submitBtnText, item }) => {
    //joi schema
    const schema = Joi.object({
        name: Joi.string().required().min(3).max(191).label("Marketplace Name"),
    });

    //react hook form setup
    const {
        register,
        handleSubmit,
        setError,
        clearErrors,
        formState: { errors },
    } = useForm({
        resolver: joiResolver(schema),
    });

    const onSubmit = async (input) => {
        submitAction(input, setError);
    };

    return (
        <div className="intro-y box p-5">
            <form id="add_marketplace_form" onSubmit={handleSubmit(onSubmit)}>
                <div>
                    <label htmlFor="crud-form-1" className="form-label">
                        Marketplace Name
                    </label>
                    <input
                        className={`form-control w-full  ${
                            errors["name"] ? "border-red-500" : ""
                        }`}
                        type="text"
                        id="name"
                        name="name"
                        autoComplete="on"
                        {...register("name")}
                        defaultValue={item.name ?? ""}
                    />
                    <ErrorSpan errors={errors} fieldName="name" />
                </div>

                <div className="text-right mt-5">
                    <button
                        type="button"
                        className="btn btn-outline-secondary w-24 mr-1"
                    >
                        Cancel
                    </button>
                    <button type="submit" className="btn btn-success w-24">
                        {submitBtnText}
                    </button>
                </div>
            </form>
        </div>
    );
};

export default MarketplaceForm;
</code>```

答:
I guess you should check validation as your validation is not working properly or see the name props

is this default value working

```<code>defaultValue={item.name ?? ""}
</code>```

Body:
I am using react-hook-form and Joi for the validataion in react. But in case of edit, if I don't touch any field and hit directly update, it shows value required, even when the field is already populated there.

But, once I focus or clicked on the input field, and hit update, then its get updated.

Here is the form:

const MarketplaceForm = ({ submitAction, submitBtnText, item }) => {
    //joi schema
    const schema = Joi.object({
        name: Joi.string().required().min(3).max(191).label("Marketplace Name"),
    });

    //react hook form setup
    const {
        register,
        handleSubmit,
        setError,
        clearErrors,
        formState: { errors },
    } = useForm({
        resolver: joiResolver(schema),
    });

    const onSubmit = async (input) => {
        submitAction(input, setError);
    };

    return (

            <form id="add_marketplace_form" onSubmit={handleSubmit(onSubmit)}>

                        Marketplace Name

                    <input
                        className={`form-control w-full  ${
                            errors["name"] ? "border-red-500" : ""
                        }`}
                        type="text"
                        id="name"
                        name="name"
                        autoComplete="on"
                        {...register("name")}
                        defaultValue={item.name ?? ""}
                    />
                    <ErrorSpan errors={errors} fieldName="name" />

                    <button
                        type="button"
                        className="btn btn-outline-secondary w-24 mr-1"
                    >
                        Cancel
                    </button>
                    <button type="submit" className="btn btn-success w-24">
                        {submitBtnText}
                    </button>

            </form>

    );
};

export default MarketplaceForm;

Body:
I guess you should check validation as your validation is not working properly or see the name props

is this default value working

defaultValue={item.name ?? ""}


问:
SCP to create a security group with no tag or with specific tag
I want to create an SCP (service control policy) that should allow creating a security group if no tags are present. If a tag is created, it should have a specific value. For example, if 'bu' is a tag, the value should always be 'finance' only. How this can be done. I have done this bit:

```<code>{
  "Sid": "SGBu",
  "Effect": "Deny",
  "Action": [
    "ec2:CreateSecurityGroup"
  ],
  "Resource": [
    "arn:aws:ec2:*:*:security-group/*"
  ],
  "Condition": {
    "ForAnyValue:Null": {
      "aws:RequestTag/bu": "false"
    }
  }
}
</code>```

How can I add an OR condition along with this so that the value has to be 'finance' if 'bu' tag is added?

Thank you

答:
You can have multiple Conditions in a SCP but these Conditions will only work as AND. But Each Condition it self can have more than one key/value pair and the relationship between these key/value pairs is OR.

Here is an example: (See the last Condition IpAdressess)

```<code>"Condition" :  {
      "DateGreaterThan" : {
         "aws:CurrentTime" : "2019-07-16T12:00:00Z"
       },
      "DateLessThan": {
         "aws:CurrentTime" : "2019-07-16T15:00:00Z"
       },
       "IpAddress" : {
          "aws:SourceIp" : ["192.0.2.0/24", "203.0.113.0/24"]
      }
}
</code>```

Here is AWS docs on it:
https://docs.aws.amazon.com/IAM/latest/UserGuide/reference_policies_multi-value-conditions.html

Body:
I want to create an SCP (service control policy) that should allow creating a security group if no tags are present. If a tag is created, it should have a specific value. For example, if 'bu' is a tag, the value should always be 'finance' only. How this can be done. I have done this bit:

{
  "Sid": "SGBu",
  "Effect": "Deny",
  "Action": [
    "ec2:CreateSecurityGroup"
  ],
  "Resource": [
    "arn:aws:ec2:*:*:security-group/*"
  ],
  "Condition": {
    "ForAnyValue:Null": {
      "aws:RequestTag/bu": "false"
    }
  }
}

How can I add an OR condition along with this so that the value has to be 'finance' if 'bu' tag is added?

Thank you

Body:
You can have multiple Conditions in a SCP but these Conditions will only work as AND. But Each Condition it self can have more than one key/value pair and the relationship between these key/value pairs is OR.

Here is an example: (See the last Condition IpAdressess)

"Condition" :  {
      "DateGreaterThan" : {
         "aws:CurrentTime" : "2019-07-16T12:00:00Z"
       },
      "DateLessThan": {
         "aws:CurrentTime" : "2019-07-16T15:00:00Z"
       },
       "IpAddress" : {
          "aws:SourceIp" : ["192.0.2.0/24", "203.0.113.0/24"]
      }
}

Here is AWS docs on it:
https://docs.aws.amazon.com/IAM/latest/UserGuide/reference_policies_multi-value-conditions.html