Using CVS file to map network drives - PowerShell

I am developing a couple of PowerShell scripts to help speed up the process of migrating user data from an old workstation to a new one. Currently trying to make one to help with retrieving and then deploying mapped network drives and have hit a snagged with the deployment aspect. I am new to PowerShell and learning as I go along using the ISE to help spot some of the problem areas the script has. Here is a copy of what the script currently looks like and the error I am receiving when trying to run it on the machine.

# Import drive list.
$mappedDrives = Import-Csv C:\Users\########\Desktop\WIP_Scripts\MasterCopy\mappedDrives.csv
$mappedDrives | %{$_ -replace ":"}
foreach ($Name in $mappedDrives) {
    New-PSDrive -Name $Name.Name -PSProvider FileSystem -Root "ProviderName" -Persist -ErrorAction Continue 
}

Once I have it working Ill make the edits for where the import comes from. The errors I am currently receiving are:

New-PSDrive : Cannot process the drive name because the drive name contains one or more of 
the following characters that are not valid: ; ~ / \ . :
At C:\Users\#######\Desktop\WIP_Scripts\MasterCopy\ImportMappedDrives.ps1:8 char:5
+     New-PSDrive -Name $Name.Name -PSProvider FileSystem -Root "Provid ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [New-PSDrive], PSArgumentException
    + FullyQualifiedErrorId : Argument,Microsoft.PowerShell.Commands.NewPSDriveCommand
 
New-PSDrive : Cannot process the drive name because the drive name contains one or more of 
the following characters that are not valid: ; ~ / \ . :
At C:\Users\#######\Desktop\WIP_Scripts\MasterCopy\ImportMappedDrives.ps1:8 char:5
+     New-PSDrive -Name $Name.Name -PSProvider FileSystem -Root "Provid ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [New-PSDrive], PSArgumentException
    + FullyQualifiedErrorId : Argument,Microsoft.PowerShell.Commands.NewPSDriveCommand
 
New-PSDrive : Cannot process the drive name because the drive name contains one or more of 
the following characters that are not valid: ; ~ / \ . :
At C:\Users\#######\Desktop\WIP_Scripts\MasterCopy\ImportMappedDrives.ps1:8 char:5
+     New-PSDrive -Name $Name.Name -PSProvider FileSystem -Root "Provid ...
+     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [New-PSDrive], PSArgumentException
    + FullyQualifiedErrorId : Argument,Microsoft.PowerShell.Commands.NewPSDriveCommand

For the script used to retrieve the drive information:

$mappedDrives = @()
$Name = Get-WmiObject -ClassName Win32_MappedLogicalDisk | Select Name, ProviderName
foreach ($Name in $Name) {
    if ($Name. ProviderName) {
        $mappedDrives += Select-Object Name, ProviderName -InputObject $Name
    }
}

$mappedDrives | Export-Csv mappedDrives.csv 

MappedDrives.csv Output

Also attached is what the mappeddrives.csv output looks like for the retrieval. I thought that the csv file may be causing the invalid character arguements since the Name found within the csv file includes the ":" character. Also I am a bit confused on whether or not it will be able to see the "ProviderName" within the csv file or if I need to declare it in order for the script to add it to its argument. Again I am extremely new to Powershell so lots of what I have written down is what I have found from this site, Microsoft, or other blogs/forums and trying to Frankenstein together a working script. Any feedback on how to improve or get this to work and/or why using another method would be better in this situation would be greatly appreciated.

###Revision 1###

Utilizing the new script provided by RetiredGeek

# Import drive list.

$CFSArgs = @{PropertyNames = "Name", "ProviderName"
             Delimiter = ','}
$MappedDrives = (Get-Content "G:\BEKDocs\Scripts\Test\mappedDrives.csv") | 
                 ConvertFrom-String @CFSArgs

for ($cnt = 1; $cnt -lt $MappedDrives.count; $cnt++) {
   $NPSDArgs = 
      @{Name        = $(($MappedDrives[$cnt].Name).Substring(0,1)) 
        PSProvider  = "FileSystem"
        Root        = "$($MappedDrives[$cnt].ProviderName)" 
        Persist     = $True
        ErrorAction = "Continue"
                }
        New-PSDrive @NPSDArgs
}

I am now receiving the following error:

New-PSDrive : When you use the Persist parameter, the root must be a file system location 
on a remote computer.
At C:\Users\######\Desktop\MasterCopy\Test2.ps1:16 char:9
+         New-PSDrive @NPSDArgs
+         ~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (":PSDriveInfo) [New-PSDrive], NotSupported 
   Exception
    + FullyQualifiedErrorId : DriveRootNotNetworkPath,Microsoft.PowerShell.Commands.NewPSD 
   riveCommand

The two questions I have now are:

1. Would it be more appropriate to use "Net use" instead of "New-PSDrive" for what I am trying to achieve(which is mapping a network drive to a computer using the cvs file created)?
2. If the use of the New-PSDrive cmdlet is a non-issue how do I rectify the error the script is currently outputting?

Thanks again to RetiredGeek and Theo for your inputs.