I think that R also quietly loads the package, eg ?"::" says that
The package namespace will be loaded if it was not loaded before the call
If you just care about namespace management, use something like
using DataFrames: DataFrame
import CSV
so that no other symbols end up in the namespace.